RE: what is the use of dependency for SQL parameters and what is the order of execution for the parameters?
By default, the dependency is set as “Initialization” of the Job Flow. This means that the SQL query associated with the SQL parameter will be executed as part of Job Flow initialization which happens before the start of execution of any job in the Job Flow.
The Job order based on which dependent job are selected, as to when the execution of the SQL parameter should happen. This could be Before or After.
- If Before is selected then, the SQL parameter will be executed just before the start of the dependent job.
- If After is selected then, the SQL parameter will be executed after the successful completion of the dependent job.