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,185 times, 4 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *