Product Dimension

In a relational data model, for normalization purposes, product category lookup, product sub-category lookup, product lookup, and and product feature lookups are are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called PRODUCT DIMENSION for performance and slicing data requirements.

Example of Product Dimension:

Product Dimension Example Diagram

Product Category Lookup:

[ultimatetables 32 /]

Product Sub-Category Lookup:

[ultimatetables 33 /]

Product Lookup:

[ultimatetables 34 /]

Product Feature Lookup:

[ultimatetables 35 /]

Product Dimension:

[ultimatetables 36 /]


Next⇒ Organization Dimension


(Visited 7,763 times, 1 visits today)

Leave a Reply

Your email address will not be published.