A mapping output in a Mapping task is a value that provides information about the Mapping task run.
You can bind a mapping output to a workflow variable to use the output in another workflow task. You can also persist the value of the output to use the value as an input parameter the next time that the Mapping task runs.
Mapping tasks return the following types of output:
General Outputs
The start time, end time, and whether the task succeeded.
System-defined Outputs
The number of error rows, source rows, and target rows that the mapping processed.
User-defined Outputs
Mapping outputs that you define to aggregate fields or expressions from each row in the mapping. Persisted user-defined outputs are values that the Data Integration Service saved to the repository from a previous workflow run. Current values are mapping output values from the current workflow run.
Perform the following tasks with mapping outputs:
Persist the mapping output in the repository.
You can configure a Mapping task to persist a mapping output value in the repository, or you can assign a persisted mapping output value to a Mapping task input.
For example, you can configure the Mapping task to return the last sequence number that it generated. You can persist the mapping output that stores the sequence number in the repository. The next time the Mapping task runs, you can use the last sequence number as the starting sequence number.
Bind the output to a workflow variable.
You can bind mapping outputs from the current Mapping task run to workflow variables. If you bind the output to a workflow variable, the workflow passes the value of the output to other tasks in the workflow. You can also bind persisted mapping outputs from a previous Mapping task run to workflow variables in the current run.