Warehouse - one dimension for multiple dates?
This is example of simple warehouse: http://en.wikipedia.org/wiki/File:Snowflake-schema-example.png
If in Fact_Sales there is still Date2_ID, Date3_ID would these two dates be related with the same Dim_Date dimension or I would have to create Di开发者_运维技巧m_Date2 and Dim_Date3 dimensions (with respective snowflake schema)?
Yes you could use the same dimension for dates, since every row has a unique id. See this for explanation (scroll to "The date dimension");
精彩评论