Date Dimension Table

Remember from the basic example that the DIM_MONTH dimension table was used. The FACT_SALARY table stored data at a monthly grain. Because the FACT_HELPDESK_TICKET stores data at a daily grain, this table is needed. Date dimensions are a bit unique since they have no source. In other words, they are not populated by an ETL job but are typically populated when the data warehouse is implemented.