Automated Data Validation for Data Warehouse Testing

Data warehouse is a system for collecting, organizing, holding and sharing historical data. It is used by the business users for decision support. Business users run queries in one manner or another on the data within the data warehouse environment to support their process. Hence, Data warehouse testing plays an important role in the system. Data warehouse testing comprises of exhaustive testing of a Data warehouse during its design and on an ongoing basis for the incremental activities. Data warehouse testing is common today because of increase in Enterprise Mergers & Acquisitions, Data Center Migrations, Increased Compliance regulations, Senior Management's increased focus on data and data driven decision making. Organization decisions depend entirely on the Enterprise data and the data has to be of utmost quality. Complex Business rules and transformation logic implementations mandates a diligent and thorough testing [3]. The manual data validation and verification process is time consuming and not accurate. This work introduces an automated data validation strategy to reduce the data warehouse testing time thus reducing the testing cost and attaining good data quality in less time.