« Integrating stand-alone BI platforms- Gradual Approach | Main | Maximizing effectiveness of Data Steward »
July 5, 2008
Data Warehouse Testing is Different
Data Warehouse testing is a specialist subject and has significant differences vis-à-vis, typical transaction system testing. The testing approach, preparation, resources and skill readiness will be driven by the DW testing being peculiar on following counts:
- User-Triggered (OLTP) v/s System triggered (Data Warehouse)
- Batch (Data Warehouse) v/s online gratification (OLTP)
- Volume of Test Data high (Data Warehouse) vs low volume (OLTP)
- Infinite Possible scenarios/ Test Cases (Data warehouse) vs. Finite Cases (OLTP)
- Test Data Preparation tricks are different for DW vs. OLTP.
- Programming for testing challenge. Generally we need to create more complex scripts for Data Warehouse.
To understand why, please refer Data Warehouse testing is different in my portal bipminstitute.com .
Posted by Rajan Gupta at July 5, 2008 11:45 AM
