PERFORMANCE CHECKING COMPONENT FOR AN ETL JOB

摘要

Generation of a performance determination report for an Extract, Transform, Load (ETL) job includes decomposing the ETL job into two or more stage instances, and identifying one or more conditions for each of the stage instances. A set of tests for each of the identified conditions are generated. A first set of test results are generated by performing the set of tests. It is determined whether a test result from the first set of test results is outside of a first range. Conditions that can be identified include a non-volatile free memory condition, a network reliability condition, a network configuration condition, an application availability condition, a database availability condition, a database performance condition, a schema validity condition, an installed libraries condition, a configuration parameter condition, a volatile free memory condition, and a third party tool condition.

主权项

1. A computer-implemented method performed by a processor for generating a performance determination report for an Extract, Transform, Load (ETL) job, comprising:
decomposing an ETL job into two or more stage instances; identifying one or more conditions for each of the stage instances; generating a set of tests for each of the identified conditions; generating a first set of test results by performing the sets of tests; determining whether a test result from the first set of test results is outside of a first range; and generating the performance determination report, the performance determination report including the test result.