What are the pros and cons of the top-down and bottom-up approaches to data warehouse development?

The top-down development of an enterprise warehouse serves as a systematic solution and minimizes integration problems. However, it is expensive, takes long dining to develop, and lacks flexibility due to the difficulty in achieving consistency and consensus for a common data model for the entire organization.

The button-up approach to the design, development, and deployment of independent data marts provides flexibility, low cost, and rapid return of investment. It, however, can lead to problems when integrating various disparate data marts into a consistent enterprise data warehouse.

Leave a Reply

%d bloggers like this: