开发者

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

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜