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