Table of Contents

Search

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

Developer Mapping Guide

Developer Mapping Guide

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.
  1. After you create a mapping, click the editor to access the mapping properties.
  2. Open the
    Outputs
    view.
  3. Create a new mapping output.
    The Developer tool creates a mapping output with default field values.
  4. Change the name that identifies the mapping output to Output_ID.
  5. Select a numeric mapping output type. Enter the precision and scale.
  6. 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.
  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 the mapping output Output_ID: The Outputs view shows the configured output Output_ID. Output_ID has the type 'double', precision set ot 15, scale set to 0, and aggregation type set to MAX.

0 COMMENTS

We’d like to hear from you!