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.

Share
Related Documents
  1. Testing Data Warehouse Applications (1732)
  2. Data Warehouse / ETL Testing: Best Practices (4959)
  3. Automated Testing for Data Warehouse Projects (1119)
  4. Test data preparation for Data base Testing (1100)
  5. DATA WAREHOUSE TESTING (2572)
  6. How to Thoroughly Test a Data Warehouse (2017)
  7. Testing for Data Ware Housing (1787)
  8. ETL & Data Test Guidelines for Large Applications (3219)
  9. Costraint-Based Automatic Test Data Generation (1623)
  10. [Free] DDD : Data Display Debugger (1552)
  11. [Paid] Accurate Network Monitor : Monitoring and analyzing network traffic data (1467)
  12. Data Storage Testing and Verification (1723)
  13. Data Mining- Concepts and Techniques solution manual (2356)
  14. Oracle Bi Testing Strategy (1027)
  15. Data Migration : Pre-migration testing (822)
  16. Data integrity testing (1329)
  17. Automatic Test Data Generation (1874)
  18. Genetic Algorithm Based Test Data Generator (1646)
  19. [Free] PHProjekt : Test Project Management Tool (2225)
  20. Data Complexity Metrics for XML Web Services (1145)