开发者

Warehouse - one dimension for multiple dates?

开发者 https://www.devze.com 2023-04-12 00:45 出处:网络
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 D

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");

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号