Step 2. Define the Mapping Output and Aggregation Type
Step 2. Define the Mapping Output and Aggregation Type
Define mapping outputs in the Outputs tab of the mapping Properties. Each mapping output definition describes what type of aggregation to perform and the data type of the results. The Output column includes both user-defined and system-defined mapping outputs.
After you create a mapping, click the editor to access the mapping properties.
Open the
Outputs
view.
Create a new mapping output.
The Developer tool creates a mapping output with default field values.
Change the name that identifies the mapping output to Output_ID.
Select a numeric mapping output type. Enter the precision and scale.
Choose the aggregation type for the mapping output as MAX to store the largest order ID processed.
When you select the aggregation type, you can choose to calculate the sum of the values that the mapping processes or find the minimum or maximum value. Default is SUM.
When you persist mapping outputs, the aggregation type is also used to compare the previously persisted value to the newly calculated value.
Click
File
Save
to save the mapping output.
You must save the mapping output before you can create a mapping output expression in the Expression transformation.
The following image shows the mapping output Output_ID: