SYSTEM AND METHOD FOR TESTING DATA AT A DATA WAREHOUSE

摘要

A system and method for performing testing of data at a data warehouse is provided. The methodology of the invention describes steps to develop and further invoke one or more data quality-accuracy test cases from a framework. The data quality-accuracy test cases check the sanity of the data stored at the data warehouse. The one or more data quality-accuracy test cases are developed based on at least one predefined strategy, which in turn are stored in the framework. The methodology further executes the developed one or more data quality-accuracy test cases as either batch or independently, based on the requirements of the test. Thereafter, the methodology maintains traceability of the executed test at the data warehouse, incorporating details from the development of the one or more data quality-accuracy test cases to the final output of the test.