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
