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

Defining Mapplet Outputs

Defining Mapplet Outputs

Create a mapplet and define the mapping outputs in the
Outputs
tab of the mapplet
Properties
view. Each mapping output definition describes what type of aggregation to perform and the data type of the results.
  1. After you create a mapplet, click inside the mapping canvas to access the mapplet 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.
  4. Change the name that identifies the mapping output.
  5. Select a numeric or date mapping output type. If you are creating a numeric 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.
    The following image shows a mapplet output called Total_Sales_Tax with an aggregation type SUM:
    The image shows a mapplet with a input, an output, and an Expression transformation. The mapplet is highlighted. The Outputs view appears at the bottom with the Total Sales Tax output.The Total Sales Tax output is type dcimal, with the precision of 10, and the scale 2. The aggregation type is SUM.
  7. Click
    File
    Save
    to save the mapping output.
    You must save the mapping output before you can create any mapping output expression in an Expression transformation.

0 COMMENTS

We’d like to hear from you!