Abstract: Embodiments relate to integrating data transform test with a data transform tool. A method and system are described for creating a data transform test for a data transform job having a data transform script, the method includes determining all data transform units available in the data transform job, determining a subset of the available data transform units for a new test, and generating a subset test execution script for the subset of data transform units from the data transform script. The method further includes determining boundary test data at each boundary of the subset of data transform units, defining a data transform test, and saving the data transform test for later testing. The data transform test includes the subset of data transform units with subset test execution script and with boundary test data.

Abstract: A computer-implemented ETL debugger for a data flow associated with an extract, transform and load (ETL) process that provides a user with a graphical representation of an ETL job. The graphical representation includes individualized representations of one or more data sources, one or more data destinations, and one or more transform operations for data flowing from a data source to a data destination. The user selects a subset of the transform operations. In response, the ETL debugger generates an execution script based on the received subset, and may initiate a debug process by executing the generated execution script.

Abstract: Embodiments relate to integrating data transform test with a data transform tool. A method and system are described for creating a data transform test for a data transform job having a data transform script, the method includes determining all data transform units available in the data transform job, determining a subset of the available data transform units for a new test, and generating a subset test execution script for the subset of data transform units from the data transform script. The method further includes determining boundary test data at each boundary of the subset of data transform units, defining a data transform test, and saving the data transform test for later testing. The data transform test includes the subset of data transform units with subset test execution script and with boundary test data.

Abstract: A computer-implemented ETL debugger for a data flow associated with an extract, transform and load (ETL) process that provides a user with a graphical representation of an ETL job. The graphical representation includes individualized representations of one or more data sources, one or more data destinations, and one or more transform operations for data flowing from a data source to a data destination. The user selects a subset of the transform operations. In response, the ETL debugger generates an execution script based on the received subset, and may initiate a debug process by executing the generated execution script.