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

Mapping Outputs In Mapplets

Mapping Outputs In Mapplets

You can configure a mapplet to return mapping outputs. You can bind the mapping outputs from a mapplet to the mapping outputs at the mapping level.
When you include a mapplet in mapping, the mapplet computes the value of the outputs and passes the output values to the mapping. You can bind more than one output from a mapplet to the same output at the mapping level. You can also bind system-defined outputs from a mapplet to the mapping outputs. The mapplet outputs and the mapping outputs must be the same type.
For example, a mapplet might return the maximum value of a Salary port, a Bonus port, and a Commission port in three mapping outputs.
The following image shows the Out_Salary, Out_Bonus, and Out_Commission mapping outputs in the
Outputs
view:
The Outputs view contains 3 mapping outputs,Out Salary, Out Bonus, and Out Commission. Each mapping output is a decimal type with precision of 10. The aggregation type is MAX. The Binding column is empty.
The
Outputs
view contains the following fields:
Name
The name of the output. Default is Output.
Type
The type of the mapping output. You can select a numeric type or a date/time type. Default is Integer.
Precision
The length of the mapping output field.
Scale
The digits to the right of the decimal in the mapping output field.
Aggregation Type
The type of aggregation to perform on the output expression. Choose SUM, MIN, or MAX. Default is SUM.
Binding
The name of an output from another mapplet to bind to this mapping output. The
Binding
field is blank unless the mapplet contains another mapplet that is returning the mapping output.
Description
The description of the mapping output.
For each mapping output in the mapplet, create an associated output expression in the Expression transformation. Each expression identifies the fields to aggregate.
The following image shows the mapping output expressions in the Expression transformation:
For this example, the Expression transformation aggregates the Salary and Commission port values. The Out_Bonus mapping output is an expression that includes the Bonus port value plus 10% of the Bonus.

0 COMMENTS

We’d like to hear from you!