Question about using date dimension keys in other dimension tables
2 posters
Page 1 of 1
Question about using date dimension keys in other dimension tables
Hi,
Users are asking for a lot of dates in dimension tables. Is it considered a violation of the no snowflaking rule to put those dates in the dimension tables as keys to the date dimension so they can use all of the cool date dimension logic? For example, a contract dimension with start and end dates of the contract in it.
Thanks
Users are asking for a lot of dates in dimension tables. Is it considered a violation of the no snowflaking rule to put those dates in the dimension tables as keys to the date dimension so they can use all of the cool date dimension logic? For example, a contract dimension with start and end dates of the contract in it.
Thanks
leadfoot- Posts : 4
Join date : 2012-01-16
Re: Question about using date dimension keys in other dimension tables
When users want to leverage the date dimension, I normally move the date FK to the fact table. The fact is though, you can easily join to the date dimension from any table using the surrogate key or the date.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Storing Date Keys in dimension tables versus fact tables
» DATE OR DATE KEYS IN FACT TABLES
» Date Dimension with multiple keys at different levels, is that normal?
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Composite Dimension Natural Keys - Attribute Used In Multiple Dimensions as well as Fact Tables
» DATE OR DATE KEYS IN FACT TABLES
» Date Dimension with multiple keys at different levels, is that normal?
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Composite Dimension Natural Keys - Attribute Used In Multiple Dimensions as well as Fact Tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum