Patent Document ID: 9471652
Application ID: 14944548

Base Claim:
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.

---

Claim 2:
2. The method as claimed in claim 1 , wherein updating stored information relating to the current job with the new input includes updating a dynamic set of rules which apply to the current job, wherein the dynamic set of rules are next stage rules and/or optimization rules.