System for analyzing the runtime impact of data files on data extraction, transformation, and loading jobs

摘要

A system for analyzing the runtime impact of data files on data extraction, transformation, and loading (ETL) jobs typically includes a processor, a memory, and a runtime impact analysis module stored in the memory. The runtime impact analysis module is typically configured for: receiving a user input comprising a designator of a data repository from a user; receiving an ETL job list file from one or more ETL servers; for each ETL job invocation name in the ETL job list file: querying the one or more ETL servers for runtime information, receiving the runtime information from the one or more ETL servers, searching the runtime information for the designator of the data repository, and if the designator of the data repository is identified in the runtime information, adding the ETL job invocation name to an impacted ETL job file; and providing the impacted ETL job file to the user.