Data Warehouse Testing
Data Warehouse Testing
By :
Kartikey Brahmkshatriya
(M.C.A)
Index
1. Introduction 3
2. About Data Warehouse 3 2.1 Data Warehouse definition 3
3. Testing Process for Data warehouse: 3 3.1 Requirements Testing : 3 3.2 Unit Testing : 4 3.3 Integration Testing : 4 3.3.1 Scenarios to be covered in Integration Testing 5 3.3.2 Validating the Report data 5 3.4 User Acceptance Testing 5
4. Conclusion 5
Introduction
This document details the testing process involved in data warehouse testing and test coverage areas. It explains the importance of data warehouse application testing and the various steps of the testing process.
About Data Warehouse
Data warehouse is the main repository of the organization's historical data. It contains the data for management's decision support system. The important factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis (data mining) on the information within data warehouse without slowing down the operational systems.
Data Warehouse definition
• Subject-oriented : Subject Oriented -Data warehouses are designed to help you analyse data. For example, to learn more about your company's sales data, you can build a warehouse that concentrates on sales. Using this warehouse, you can answer questions like "Who was our best customer for this item last year?" This ability to define a data warehouse by subject matter, sales in this case, makes the data warehouse subject oriented. The data is organized so that all the data elements relating to the same real-world event or object are linked together.
• Integrated : Integration is closely related to subject orientation. Data warehouses must put data from disparate sources into a consistent format. The database contains data from most or all of an organization's operational applications and is made consistent.
• Time-variant : The changes to the data in the
By :
Kartikey Brahmkshatriya
(M.C.A)
Index
1. Introduction 3
2. About Data Warehouse 3 2.1 Data Warehouse definition 3
3. Testing Process for Data warehouse: 3 3.1 Requirements Testing : 3 3.2 Unit Testing : 4 3.3 Integration Testing : 4 3.3.1 Scenarios to be covered in Integration Testing 5 3.3.2 Validating the Report data 5 3.4 User Acceptance Testing 5
4. Conclusion 5
Introduction
This document details the testing process involved in data warehouse testing and test coverage areas. It explains the importance of data warehouse application testing and the various steps of the testing process.
About Data Warehouse
Data warehouse is the main repository of the organization's historical data. It contains the data for management's decision support system. The important factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis (data mining) on the information within data warehouse without slowing down the operational systems.
Data Warehouse definition
• Subject-oriented : Subject Oriented -Data warehouses are designed to help you analyse data. For example, to learn more about your company's sales data, you can build a warehouse that concentrates on sales. Using this warehouse, you can answer questions like "Who was our best customer for this item last year?" This ability to define a data warehouse by subject matter, sales in this case, makes the data warehouse subject oriented. The data is organized so that all the data elements relating to the same real-world event or object are linked together.
• Integrated : Integration is closely related to subject orientation. Data warehouses must put data from disparate sources into a consistent format. The database contains data from most or all of an organization's operational applications and is made consistent.
• Time-variant : The changes to the data in the