background preloader

Data Warehouse Modeling

Facebook Twitter

Hierarchies

When modeling a new data warehouse, Do I put each hierarchy into. Q: I am modeling a new data warehouse.

When modeling a new data warehouse, Do I put each hierarchy into

I will be pulling some hierarchy data from a source system that stores multiple hierarchies in one table. I know that I need to break the data out into separate structures for each hierarchy (product line, organization, etc.) Book Chapter. Flexible and efficient information ...