Developer Workflow Guide

10.2.1
- 10.5.6
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2

Back Next

Mapping Task Output

Mapping task output is the data that passes from a Mapping task to workflow variables.

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.

Configure the Mapping task output values that you want to assign to workflow variables on the

Output

tab. The Data Integration Service copies the Mapping task output values to workflow variables when the Mapping task completes.

The following image shows some mapping outputs on the Mapping task

Output

tab:

To assign a workflow variable to a Mapping task output, click the Variable column. Choose a workflow variable to assign the output to. In the example image, the Total_OrderAmt mapping output from the current workflow run is bound to the workflow variable

wf_Variable_Total_orderAmt

If a task fails, the Data Integration Service copies the general task output values but not the task specific output values to workflow variables. If the task aborts, the Data Integration Service does not copy any task output value to workflow variables.

Example

A Mapping task includes a number of error rows output value that captures the number of rows that the mapping failed to process. To use the data in the remainder of the workflow, you assign the number of error rows output to a workflow variable named MappingErrorRows. Then you can add the MappingErrorRows workflow variable in an expression for an outgoing sequence flow from an Exclusive gateway. If MappingErrorRows contains a value greater than zero, the gateway takes one branch. If the value equals zero, the gateway takes the other branch.

Mapping Task

System-Defined Mapping Outputs

Task Output

Assign a Value with Task Output

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal