Developer Mapping Guide

10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2
- 10.2.1

Back Next

Mapping Outputs Overview

A mapping can return mapping outputs. A mapping output is a single value that is the result of aggregating a field or expression from each row that the mapping processes.

A mapping output returns a value that provides information about the mapping run. For example, a mapping output can return the number of error rows that the mapping found. A mapping output can return the latest order date that the mapping processed and the total amount of all the orders.

The mapping returns each mapping value when the mapping completes. You can define multiple mapping outputs in the same mapping.

A mapping can return user-defined mapping outputs or system-defined mapping outputs.

You can bind mapping outputs to mapping parameters. The mapping uses the persisted output from a previous run as the value for a parameter the next time the mapping runs. You cannot directly use the mapping output in a transformation, but you can use the parameter that is bound to the mapping output. If there is no persisted output value, the parameter uses a default value.

User-defined mapping outputs: A user-defined mapping output is a numeric value or date that a mapping returns by aggregating a field or expression from each row in the mapping. For example, you might need to know when orders reach a specific threshold. You can configure the mapping to return the total order amount that the mapping processed. Define a mapping output called TotalOrderAmt and configure the mapping to summarize the Order_Amount field from every row. Define an expression or port name to aggregate in an Expression transformation.
System-defined mapping outputs: A system-defined mapping output is a built-in value that the mapping always returns whenever the mapping completes. The mapping returns the number of source rows, the number of target rows, and the number of error rows that the mapping processes. You do not have to define a system-defined mapping output.

If the mapping runs as a Mapping task in a workflow, you can persist the mapping output in the repository or bind the mapping output to a workflow variable.

For information on mapping outputs in Mapping tasks, see the "Mapping Task" chapter in the

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Mapping Outputs Overview

Mapping Outputs Overview