What is the difference between top down and bottom up enterprise data warehouse design?
meda Selected answer as best 20/10/2022
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.
meda Selected answer as best 20/10/2022