Search code examples
datedimensionsnowflake-schema

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 Dim_Date2 and Dim_Date3 dimensions (with respective snowflake schema)?

Solution

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