GOOD Data Warehouse Concepts for ETL testers

What is a Data Warehouse? According to Inmon, famous author for several data warehouse books, "A data warehouse is a subject oriented, integrated, time variant, non volatile collection of data in support of management's decision making process".
Example: In order to store data, over the years, many application designers in each branch have made their individual decisions as to how an application and database should be built. So source systems will be different in naming conventions, variable measurements, encoding structures, and physical attributes of data. Consider a bank that has got several branches in several countries, has millions of customers and the lines of business of the enterprise are savings, and loans. The following example explains how the data is integrated from source systems to target systems.

  1. [2011/06/15] Testing Data Warehouse Applications *2 by binuhill (1811)
  2. [2009/07/31] Data Warehouse / ETL Testing: Best Practices *2 by ksr (5139)
  3. [2012/05/02] Automated Testing for Data Warehouse Projects *2 by rladmf (1231)
  4. [2012/07/11] Test data preparation for Data base Testing *2 by ram42 (1232)
  5. [2009/04/19] DATA WAREHOUSE TESTING *2 by rks (2678)