When modeling a new data warehouse, Do I put each hierarchy into. Q: I am modeling a new data warehouse.
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 ...