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

How to Configure Mapping Outputs

How to Configure Mapping Outputs

When you configure mapping outputs, define the mapping outputs at the mapping level, configure the expressions to aggregate at the transformation level, and persist the results at the Mapping task level.
The following image shows the process to configure mapping outputs:
To configure mapping outputs, perform the following steps:
  1. Create the mapping.
  2. In the
    Outputs
    view of the mapping, define the mapping output name and type of aggregation.
  3. Add an Expression transformation to the mapping and configure the mapping output expression in the Expression
    Mapping Outputs
    view.
  4. To create a Mapping task, add the mapping to a workflow .
  5. Persist the mapping output in the Mapping task
    Persistence
    view and configure the aggregation function type for the persisted value.
  6. Assign the persisted mapping output to an input parameter in the Mapping task.
  7. If you want to use the mapping output in another workflow task, assign the mapping output to a workflow variable .

0 COMMENTS

We’d like to hear from you!