Extract transform load input suggestion

摘要

Methods and systems are provided for extract transform load (ETL) input suggestion for an ETL system in which a current job is being created. A method includes: determining when a new input is made in the current job in the ETL system and dynamically receiving the new input; updating stored information relating to the current job with the new input; accessing rules which apply to the current job; analyzing and applying the rules based on the new input and the current job stored information to generate one or more suggested next inputs in the current job; providing a weighting for the one or more suggested next inputs based on the analysis and application of the rules; and providing a prompt in the current job in the ETL system with the suggested one or more next inputs and their weightings.

主权项

1. A computer-implemented method for extract transform load (ETL) input suggestion for an ETL system in which a current job is being created, comprising:
determining, by a computer processor, when a new input is made in the current job in the ETL system and dynamically receiving the new input, the new input a new stage input; updating stored information relating to the current job with the new input; accessing rules which apply to the current job, the rules including next stage rules; analyzing and applying, by the computer processor, the rules based on the new input and the current job stored information to generate one or more suggested next inputs in the current job, the one or more suggested next inputs including suggested next stages; providing a weighting for the one or more suggested next inputs based on the analysis and application of the rules; and providing a prompt in the current job in the ETL system with the suggested one or more next inputs and their weightings, wherein in response to the new input being the new stage input:
the next stage rules include dynamic rules including:built-in patterns of existing stages in the current job; and dynamic patterns based on previous usage of stages in job designs within the current job environment.