DW and QA Project - I

In the coming posts, I will discuss about a Data Mart from QA point of view.
As we know, data mart can be thought of as a smaller data warehouse.
From QA perspective, the entire DM project can be divided into following modules:
- ETL
- Database
- Universe
- Reports

Starting point for this project can be following documents:
- Data mart schema (fact and dim tables etc)
- Report specifications

First task is to come up with a test plan. One single test plan can be created, that will have 4 sections for each of the 4 modules (mentioned above).
A list of possible test scenarios should be included in the test plan.
After the test plan is created and approved, the next task would be to create test cases. That will be discussed in the next posting.

Useful Links about Data WareHouse

Data Warehouse
Data Warehousing Guide
Kimball Group: Data Warehouse Training: Articles
ETL: Simple Tutorial from Microsoft
ETL Guru