Design of the Time dimension table in the dimensional modeling

After de-normalization, your Time table will look like this:

Time Dimension Table Schema

Field Name Type
Dim_Id INTEGER (4)
Month SMALL INTEGER (2)
Month_Name VARCHAR (3)
Quarter SMALL INTEGER (4)
Quarter_Name VARCHAR (2)
Year SMALL INTEGER (2)

The actual data in your Time Table may will look like this:

Time Dimension Data

TM _Dim_Id TM _Month TM _Month_Name TM _Quarter TM _Quarter_Name TM_Year
1001 1 Jan 1 Q1 2003
1002 2 Feb 1 Q1 2003
1003 3 Mar 1 Q1 2003
1004 4 Apr 2 Q2 2003
1005 5 May 2 Q2 2003
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .