Table of Contents

Search

  1. Preface
  2. Workflows
  3. Workflow Variables
  4. Workflow Parameters
  5. Cluster Tasks
  6. Command Task
  7. Human Task
  8. Mapping Task
  9. Notification Task
  10. Gateways
  11. Workflow Recovery
  12. Workflow Administration

Developer Workflow Guide

Developer Workflow Guide

Defining Mapping Outputs

Defining Mapping Outputs

Create a mapping and define the mapping outputs in the mapping
Properties
. Each mapping output definition describes what type of aggregation to perform and the data type of the results.
  1. After you create a mapping, click the editor to access the mapping
    Properties
    .
  2. Click the
    Outputs
    view.
  3. Click
    New
    to create a mapping output.
    The Developer tool creates a mapping output with default field values.
    The following image shows the mapping output default values in the
    Outputs
    view:
    The Outputs view shows the default values for a mapping output. The mapping output name is Output. The type is integer, the precision is 10 and the aggregation type is SUM.
  4. Change the name that identifies the mapping output.
  5. Select a numeric or date mapping output type. Enter the precision and scale.
  6. Choose the aggregation type for the mapping output.
    You can summarize the output expression or you can find the minimum or maximum expression value that the mapping processed. Default is SUM.
  7. 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 a mapping output that contains the sum of a decimal field and a mapping output that contains a maximum date value:
The Outputs view contains the Total Order Amount mapping output which is a decimal type with a SUM aggregation type. It also shows Last Order Date, which is a date/time type with a MAX aggregation type.

0 COMMENTS

We’d like to hear from you!