The Transformation Executor step allows you to execute a Pentaho Data Integration (PDI) transformation. It is similar to the Job Executor step, but works with transformations.
Depending on your data transformation needs, the Transformation Executor step can be set up to function in any of the following ways:
- By default, the specified transformation will be executed once for each input row. You can use the input row to set parameters and variables. The executor step then passes this row to the transformation in the form of a result row.
- You can also pass a group of records based on the value in a field, so that when the field value changes dynamically, the specified transformation is executed. In these cases, the first row in the group of rows is used to set parameters or variables in the transformation. Note: This function is not currently supported by the Adaptive Execution Layer.
- You can launch multiple copies of this step to assist in parallel transformation processing.