AUTOMATIC GENERATION OF AN EXTRACT, TRANSFORM, LOAD (ETL) JOB

摘要

According to one embodiment of the present invention, a method automatically generates one or more Extract, Transform and Load (ETL) jobs. Input data in a source format and output data in a target format is received. The input data and output data is analyzed to determine properties and relationships thereof. One or more mapping models are automatically generated using the properties and relationships, wherein the mapping models describe the mapping and transformation of the input data to the output data. One or more ETL jobs are generated using the mapping models. Embodiments further include a system and program product apparatus for automatically generating one or more ETL jobs.

主权项

1. A computer-implemented method for automatically generating one or more Extract, Transform and Load (ETL) jobs comprising:
receiving input data in a source format and output data in a target format; analyzing the input data and output data to determine properties and relationships thereof; automatically generating one or more mapping models using the properties and relationships, wherein the mapping models describe the mapping and transformation of the input data to the output data; and generating one or more ETL jobs using the mapping models.