Forum Discussion
Solved
Data Modeling: Show dimensions side by side
Hi all, I need to make a report for our warehouse which will show the item in a given location along with the item and location dimensions. Location Location Height Location Width Loca...
I think the answer is to consolidate, i.e. flatten, dimension tables so the schema is star and not snowflake. Basically if a dimension table has a parent table there probably is a way to combine them to simplify the schema.
I think the answer is to consolidate, i.e. flatten, dimension tables so the schema is star and not snowflake. Basically if a dimension table has a parent table there probably is a way to combine them to simplify the schema.