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 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
Related Posts
(Visited 7,763 times, 1 visits today)