What is the difference between top down and bottom up enterprise data warehouse design?
Auto Amazon Links: No products found.
In data warehouse development process we follow either top down or bottom-up development methodology.
In bottom-up approach data marts (a departmental data warehouse that stores only relevant data) are first created and integrated (bus architecture) to an enterprise data warehouse .
And in top down approach the data warehouse is built first and data marts are then created from the data warehouse.
Both approaches have their own pros and cons.
Auto Amazon Links: No products found.