Run Transformation Component

Run Transformation Component

Run a transformation job to completion. After the transformation completes, other orchestration components can be linked to this one depending upon success or fail.

Properties

Property Setting Description
Name Text The descriptive name for the component.
Transformation Name Select Choose an existing existing Transformation jobs.
Overwrite Variables Yes/No Use a set of defined variables for the called Transformation, rather than its default variable values. Note only local variables can be set via this method.
Set Variables Select Many Define local job variables to be used by the called Transformation. A variable can be added by clicking the + button, then selecting it from the dropdown list. A value can then be assigned to this variable to be used by the Transformation. Note that the assigned value must be of the correct type as given when the variable was declared. If choosing a variable name that has been defined as both an environment and job variable, the job variable will be used.

If a global variable named 'Message' is passed using this method, it can be later exported from this component (keeping any changes to the value that occurred within the Run Orchestration job) using the 'Message' export variable.

Example

This orchestration job simply runs the Sample Job transformation. Notice that the available outputs to this component are green and red. Further components connected to the 'green' connector run only when this component runs successfully. Components connected to the 'red' connector run only when this component fails in some way.

A name is set, along with the Transformation Job to run.

We don't want this Transformation to use its default 'test' value, so we set it manually but setting 'Overwrite Variables' to 'Yes' and using the 'Set Variables' property to assign the 'test' variable a new value of our choosing.