Patent ID: 9037549
Filing Date: 2015-05-19
Classification: G06F

Abstract:
1. A computer-implemented method for performing end-to-end testing of data stored at a data warehouse, the method comprising: presenting to a tester, a plurality of pre-defined testing strategies for checking at least one of accuracy and quality of data stored in the data warehouse, wherein the data stored in the data warehouse is derived by subjecting data from at least one source database to at least one transformation function, wherein each of the plurality of pre-defined testing strategies defines a methodology to validate data stored in the data warehouse against sample data derived from a source database, wherein the sample data has been subjected to the same transformation logic that was used while storing data in the data warehouse, and wherein the plurality of pre-defined testing strategies include, for identifying differences between data stored in the data warehouse and the sample data, at least two of: receiving input from the tester via a user interface on a computing device, t h e input identifying at least one testing requirement defining an attribute of the test; receiving input from the tester via the user interface, further identifying at least one predefined testing strategy from among the plurality of predefined testing strategies; developing, using a computing device, at least one test case for validating data stored in the data warehouse against sample data, based on (i) the identified at least one testing requirement and on (ii) the identified at least one predefined strategy; creating one or more scripts for executing the at least one test case at the data warehouse; defining a business rule for checking the validity of the data at the data warehouse; comparing the data stored at the data warehouse to a sample data for verifying the accuracy of the data; generating the sample data with the help of one or more transformation logics, wherein the sample data is used to identify error in the data stored at the data warehouse; analyzing the quality of the data stored at the data warehouse; executing, using a computing device, the developed at least one test case based on at least one predefined execution rule to produce output results, wherein the predefined execution rule is assigned by the tester; and generating a result encapsulating the output of the executed at least one test case at the data warehouse; and generating a report, using a computing device, encompassing output results of the end-to-end testing of data.