Automated Data Warehouse Testing

www.arkenstone-ltd.com

This book aims to assist QA (Quality Assurance) teams in performing data warehouse testing effectively using automation. The complexities and challenges of data warehouse development have evolved over the past few years and testing teams are now expected to verify each implementation by running tests multiple times to ensure the system hasn't regressed. Volumes of data are fed into the data warehouse through heterogeneous sources having data quality issues at source. Extract, Transform, Load (ETL) processes have grown too complex. Data warehouse testing is usually associated with a very high cost of quality and any defect slippage has a significant effect on downstream end-user systems. As a result, the ability to perform automated test becomes extremely useful as it provides testers and the organisation as a whole an added level of confidence.