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

Configuring a Mapping Output Expression in a Mapplet

Configuring a Mapping Output Expression in a Mapplet

Configure the expression to aggregate for each row that the mapplet processes.
  1. Add an Expression transformation to the mapplet.
    Consider the mapplet logic before you decide where to place the transformation.
  2. In the Expression transformation, click the
    Mapping Outputs
    view.
  3. Click
    New
    to add an output expression.
    The Developer tool creates a mapping output with a output name that matches one of the mapping outputs you created at the mapplet level. You might have more than one output to choose from.
  4. Enter an expression with the Expression Editor.
    The expression can contain a port name or it can contain functions, ports, and parameters.
  5. Click
    Validate
    to verify that the expression is valid.
  6. Click
    OK
    to save the expression.
    The following image shows the
    Mapping Outputs
    view with a mapping output expression that calculates a sales tax:
    The image shows an Expression transformation highlighted in a mapping. The Mapping Outputs view of the transformation contains the Total_Sales_Tax .The mapping output expression is OrderID * .065
  7. Click
    File
    Save
    to save the Expression transformation.

0 COMMENTS

We’d like to hear from you!