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...
Unpivot 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).
yes, that looks right.