Effective in version 10.0, you can create mapping outputs that return aggregated values from the mapping run. Mapping outputs are the result of aggregating a field value or an expression from each row that a mapping processes.

For example, you can configure a mapping output to summarize the total amount of an order field from the source rows that the transformation receives. You can persist a mapping output value in the repository. You can assign a persisted mapping output value to the Mapping task input parameter. You can also assign mapping outputs to workflow variables.

Create a mapping output in the mapping

Outputs

view. Define the expression to aggregate in an Expression transformation in the mapping.

For more information, see the

Informatica 10.0 Developer Mapping Guide

.