Monday, 31 October 2022

What is a Data Warehouse?

A Data Warehouse (DW) is a relational database that is designed for query and analysis rather than transaction processing.

It includes historical data derived from transaction data from single and multiple sources.

A Data Warehouse provides integrated, enterprise-wide, historical data and focuses on providing support for decision-makers for data modeling and analysis.

The key features of Datawarehouse are : 

- Subject-oriented

- Integrated

- Time variant

- Non-volatile


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to perform regression testing in ETL?

Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...

  • Explain incremental data loading?
    Incremental data loading is a technique used in ETL (Extract, Transform, Load) processes to load only the new or changed data since the last...
  • How to perform regression testing in ETL?
    Regression testing in ETL (Extract, Transform, Load) ensures that changes or updates to the ETL process do not negatively impact existing fu...
  • Dimensional Modeling?
      Dimensional modeling is a design technique used in data warehousing to structure data for efficient querying and reporting. It organizes d...