Patent ID: 10929281

Abstract:
The invention relates to a computer-implemented system and method for data transformation testing in an extract-transform-load (ETL) system. The method may be conducted on a specially programmed computer system comprising one or more computer processors, electronic storage devices, and networks. The method may comprise the steps of: retrieving input data from a data source; using the input data as input to an actual data transformation to generate actual transformed data, wherein the actual data transformation is executed by the ETL system; using the input data as input to a test module to generate expected transformed data, wherein the input data is dynamically retrieved from the data source and the test module is part of the ETL system; automatically generating documentation for the test module based on comments within the test module; automatically comparing the actual transformed data to the expected transformed data; and generating a report based on the comparison. The method may also comprise monitoring and tracking a number of scenarios automatically, according to a predefined, desired schedule. The invention also relates to computer-implemented system for data transformation testing in an extract-transform-load (ETL) system.