AdventureWorksDW2008 - dimension table references other dimension table
4 posters
Page 1 of 1
AdventureWorksDW2008 - dimension table references other dimension table
In AdventureWorksDW2008, one of the dimension tables, DimCustomer references DimGeography via the column GeographyKey. Does this break the Kimball and star schema rules for data warehouse design? If it was designed according to Kimball’s rules, wouldn’t the DimGeography details be listed in DimCustomer in a denormalized structure, so you wouldn’t have to join with DimGeography at all? Am I right about this or am I missing something? If I am correct about this, does this make it bad design or just an alternative design?
Thank you!!
Thank you!!
JimmyRichards- Posts : 1
Join date : 2012-03-24
Re: AdventureWorksDW2008 - dimension table references other dimension table
Yes, its a snowflake. Its not ideal. If you want to avoid a snowflake you would put the geography attributes in the customer dimension.
Re: AdventureWorksDW2008 - dimension table references other dimension table
It's actually an Outrigger. The SalesTerritory dimension also has a GeographyKey.
So it's actually in accord with the Kimball approach.
So it's actually in accord with the Kimball approach.
Re: AdventureWorksDW2008 - dimension table references other dimension table
Outrigger, snowflake, it's still a dimension with a FK to another dimension. Also, Kimball isn't against it (I don't think he is 'against' anything), it's just that it should be used if appropriate for the situation. In fact, he has published situations where snowflaking is recommended.
Re: AdventureWorksDW2008 - dimension table references other dimension table
If you have aggregate totals on territory then go by this design and have territory independant dim having S.key in the fact.
If you have very big customer dim then again you should go by this design as it won't bloat the customer dim.
If you have very big customer dim then again you should go by this design as it won't bloat the customer dim.
Vishy- Posts : 75
Join date : 2012-02-28
Location : India
Similar topics
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» joining dimension table to dimension and again fact table
» Can a dimension table directly link to another dimension table?
» Large Dimension table compared to fact table?
» joining dimension table to dimension and again fact table
» Can a dimension table directly link to another dimension table?
» Large Dimension table compared to fact table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum