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...
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
Super User
Super Useryes, that looks right.