Which approach is suitable for your data warehouse?

Which of the following is approach of data warehousing?

In a nutshell, here are the two approaches: in Bill Inmon's enterprise data warehouse approach (the top-down design), a normalised data model is designed first, then the dimensional data marts, which contain data required for specific business processes or specific departments, are created from the data warehouse.

What is the recommended approach for data warehouse development?

At present there are two main competing approaches being advocated for data warehouse development: top-down and bottom-up. In addition, independent data mart and the federated architecture approach are two other approaches that are also applied for data warehouse development today.

What are the most common approaches in data warehousing?

There are 2 approaches for constructing data-warehouse: Top-down approach and Bottom-up approach are explained as below.1Top-down approach: The essential components are discussed below:2Bottom-up approach: First, the data is extracted from external sources (same as happens in top-down approach).Data Warehouse Architecture - GeeksforGeeks

What is data warehouse approach?

In the "Top-Down" design approach, a data warehouse is described as a subject-oriented, time-variant, non-volatile and integrated data repository for the entire enterprise data from different sources are validated, reformatted and saved in a normalized (up to 3NF) database as the data warehouse.