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