Loop Job

image_pdfimage_print

This job does the multiple processing of another parameter-dependent load or job with differing variables.

The processing of parameter-dependent sources is defined as follows:

  • An execution that is defined by the execution type (load or job) and the name of the load or job. The execution is processed with one or more variables as parameters. For example, the variables can be used in a relational extract with a parameterized SQL or a cube load with a parameterized cube name.
  • A loop source that contains the values for the variables. The number of columns is the same as the number of variables that are applied to the execution. The number of rows defines the number of iterations for the execution.

Note that the names of the columns in the loop source have to match the names of the variables used in the execution.

This job can also be used to set variables dynamically for a load or a job. Therefore, the loop source has to contain only one row and a column with the corresponding name for each variable that should be set. In order to set variables statically, a Constant Table extract can be used as loop source.

Advanced settings

Fail on status: if the job executes several loads or subjobs, the selected option defines the behavior in case of a warning or an error message in one of the loads or subjobs. The options are described below:

none:

All subsequent loads or subjobs are executed. The job terminates with “Completed with warnings” or “Completed with errors”.

error:

In case of a warning message, the subsequent loads or subjobs are executed and the job terminates with status “Completed with warnings”. In case of an error message, the job terminates without executing subsequent loads or subjobs with status “Failed” (this was the behavior of a job until release 5.1).

warning:

In case of a warning message, the job terminates without executing subsequent loads or subjobs and the job terminates with status “Failed”.

Example:

Variables: level1
Loop source: level1   receiving Jan | Feb | Mar
Execution: Load OneMonth

In the loop job, the load OneMonth will be executed 3 times:

  1. with Variable level1=”Jan”
  2. with Variable level1=”Feb”
  3. with Variable level1=”Mar”

 

image_pdfimage_print
Was this post helpful?
NoYes (-8 rating, 8 votes)
Loading...