What is the recommended approach for data warehouse development?

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.

What are the steps in the development of data warehouses?

7 Steps to Data Warehousing1Step 1: Determine Business Objectives. ... 2Step 2: Collect and Analyze Information. ... 3Step 3: Identify Core Business Processes. ... 4Step 4: Construct a Conceptual Data Model. ... 5Step 5: Locate Data Sources and Plan Data Transformations. ... 6Step 6: Set Tracking Duration. ... 7Step 7: Implement the Plan.

What is top-down approach and bottom-up approach in data warehousing?

Bottom-up approach: First, the data is extracted from external sources (same as happens in top-down approach). Then, the data go through the staging area (as explained above) and loaded into data marts instead of datawarehouse. The data marts are created first and provide reporting capability.

What are the best practices in data warehousing?

Best Practices for Building a Data WarehouseIdentify Why You Need a Data Warehouse. ... Have an Agile Approach Instead of a Big Bang Approach. ... Analyze and Understand Your Data. ... Analyze How Frequently You Need to Load Data. ... Define a Change Data Capture (CDC) Policy for Real-Time Data. ... Prefer ELT Tools Instead of ETL.