Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Mapping Outputs
  6. Generate a Mapping from an SQL Query
  7. Dynamic Mappings
  8. How to Develop and Run a Dynamic Mapping
  9. Dynamic Mapping Use Cases
  10. Mapping Administration
  11. Export to PowerCenter
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping 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!