Tutorials -> Dimensional Modeling Tutorials
Time Dimension Table
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 |
Next>> Product
Dimension
