Product Dimension Table Schema

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

Product Dimension Table Schema

Field Name Type
Dim_Id INTEGER (4)
SKU VARCHAR (10)
Name VARCHAR (30)
Category VARCHAR (30)

In this table PR_Dim_Id is our dimension Id. This is the unique key into our Product dimension table. The actual data in your Product Table may look like this:

Product Dimension Table Data

Dim_Id SKU Name Category
1001 DOVE6K Dove SOAP 6Pk Sanitary
1002 MLK66F# Skim Milk 1 Gal Dairy
1003 SMKSAL55 Smoked Salmon 6oz Meat
<<< Design of the Time dimension table in the dimensional modelingFact Table Schema >>>
Copyright 2005-2016 KnowledgeHills. Privacy Policy. Contact .