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

Bind Mapplet Outputs to Mapping Outputs

Bind Mapplet Outputs to Mapping Outputs

If a mapplet computes mapping outputs, you need to pass the output values from the mapplet to a mapping.
Bind the mapplet outputs to the mapping outputs on the mapping
Outputs
view.
The following image shows the Max_Compensation mapping output at the mapping level:
The image shows a simple mapping with with a Compensation mapplet in it. The Max_Compensation mapping output is a decimal type with precision of 10. The Aggregation Function is set to MAX. The Binding field is empty. The description says highest payment.
At the mapping level, you can bind the Salary mapplet output, the Bonus mapplet output, and the Commission mapplet output to the same mapping output called Max_Compensation.
To bind a mapplet output to a mapping output, click the
Binding
column for the mapping output. A list of available mapplet outputs appears. The list contains mapplet outputs that are the same type and aggregation as the mapping output. Select the mapplet outputs to assign to the mapping output.
The following image shows the
Outputs Binding
dialog box:
The Output Bindings dialog box shows three mapping outputs. Each mapping output has a check box that is selected. The 3 mapping outputs are Out Salary, Out Bonus, and Out Commission.
After you select the outputs to bind to Max_Compensation, the
Binding
field contains the following text:
Mplt_Compensation.Out_Salary,Mplt_Compensation.Out_Bonus,Mplt_Compensation.Out_Commission
The following image shows the mapping outputs in the
Binding
field:
The mapping Outputs view contains the Max Compensation mapping output. The type is decimal, length is 10. The Binding field shows each mapplet output separated by commas.
Set the mapping output aggregation type is MAX. The Data Integration Service returns the highest compensation value that it finds from the Salary, the Bonus, or the Commission ports.

0 COMMENTS

We’d like to hear from you!