Forum Discussion
Flat File to Star Schema
Hi, Although a lot of posts exist on this topic "Flatfile to star schema", I have been unable to wrap around the process that suits my situation. I have a flat file that looks like the follow...
lbendlin
Super User
Super UserUnpivot your population group data. Separate out the dimensions you mentioned and replace them with integer keys in the fact table.
Thank you! When you say unpivot, how would the table look like - Would it look like the following with figures only in one column?
Geography Sex Age Groups Residence Setting
Group Value GeoKey SKey AgeKey ResKey
GroupKey_Pop#1 100 GeoKey SKey AgeKey ResKey
GroupKey_Pop#2 20 I understand that the geography table will have just a list of all geographies, similar for Sex (Total, Male and Female), Age (all ages) and Residence Setting (Apartment, detached, semi-detached).
- lbendlin
yes, that looks right.