- Dimensional Modeling tutorial – OLAP, data warehouse design
- What is Online Transaction Processing (OLTP) Schema?
- What is a Dimension Table in the Dimensional Modeling?
- Design of the Time dimension table in the dimensional modeling
- Product Dimension Table Schema
- Fact Table Schema
- Star Schema of OLAP
- Mapping of Reports to Star Schema
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 |