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: