Description of the illustration dwhsg_dt_001.png

This figure shows the following star schema tables:

• TIME_DIM

• SALES_FACT

• PRODUCT_DIM

• GEOGRAPHY_DIM

The columns of the TIME_DIM table are:

• YEAR_ID

• YEAR_NAME

• YEAR_END_DATE

• QUARTER_ID

• QUARTER_NAME

• QUARTER_END_DATE

• QUARTER_OF_YEAR

• MONTH_ID

• MONTH_NAME

• MONTH_LONG_NAME

• MONTH_END_DATE

• MONTH_OF_YEAR

• SEASON

• SEASON_ORDER

• MONTH_OF_QUARTER

The columns of the SALES_FACT table are:

• MONTH_ID

• CATEGORY_ID

• STATE_PROVINCE_ID

• SALES

• UNITS

The columns of the PRODUCT_DIM table are:

• DEPARTMENT_ID

• DEPARTMENT_NAME

• CATEGORY_ID

• CATEGORY_NAME

The columns of the GEOGRAPHY_DIM table are:

• REGION_ID

• REGION_NAME

• COUNTRY_ID

• COUNTRY_NAME

• STATE_PROVINCE_ID

• STATE_PROVINCE_NAME

In the SALES_FACT table, the MONTH_ID, DEPARTMENT_ID, and STATE_PROVINCE_ID columns are foreign keys to the TIME_DIM, PRODUCT_DIM, and GEOGRAPHY_DIM dimension tables, respectively.