I have an interesting problem with a fact table that I'm creating. In the source data, which relates to school enrollment, some sources provide separate enrollment data for male and female, and others only provide it for all students, regardless of gender. It seems bad to create an entirely separate fact table for just the gender business, but at the same time, each row would have a slightly different granularity if I kept them in the table, and slicing on gender lines wouldn't give an accurate representation of the data. The same holds true for demographic data, where some schools report enrollment broken down by ethnicity, and and some don't. What's the best way to proceed with this?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.