Developer Mapping Guide

Back Next

Outputs View

Define the mapping outputs in the

Outputs

view of the mapping

Properties

. When you define each mapping output, enter a mapping output name, the mapping output type, and the type of aggregation to perform.

The following image shows the mapping outputs in the

Outputs

tab of the mapping

Properties

view:

The

Outputs

view contains the following fields:

Name

The name of the output. Default is Output.

Type

The type of the mapping output. You can select a numeric type or a date/time type. Default is Integer.

Precision

The length of the mapping output field. Default is 10.

Scale

The digits to the right of the decimal in the mapping output field. Default is zero.

Aggregation Type

You can choose one of the following types of aggregation:

SUM: Returns the sum of the field or expression from each input row that the Data Integration Service processed.
MIN: Returns the smallest numeric value or date that the Data Integration Service processed from a specific field or expression in each input row.

MAX: Returns the largest numeric value or date that the Data Integration Service processed from a specific field or expression in each input row.

Binding: The name of a mapplet or logical data object output to bind to the mapping output. This field is blank unless the mapping output is returned from a mapplet instead of from an Expression transformation in the mapping.