When you configure mapping outputs, define the mapping outputs at the mapping level, configure the expressions to aggregate at the transformation level, and persist the results at the Mapping task level.
The following image shows the process to configure mapping outputs:
To configure mapping outputs, perform the following steps:
Create the mapping.
In the
Outputs
view of the mapping, define the mapping output name and type of aggregation.
Add an Expression transformation to the mapping and configure the mapping output expression in the Expression
Mapping Outputs
view.
To create a Mapping task, add the mapping to a workflow .
Persist the mapping output in the Mapping task
Persistence
view and configure the aggregation function type for the persisted value.
Assign the persisted mapping output to an input parameter in the Mapping task.
If you want to use the mapping output in another workflow task, assign the mapping output to a workflow variable .