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

Mapplet Parameters in Mappings

Mapplet Parameters in Mappings

When you add a mapplet with mapplet parameters to a mapping, you can set the instance values for the mapplet parameters. The instance value of a mapplet parameter is the parameter value for a specific mapping.
Set the instance value on the mapplet
Parameters
tab in the
Properties
view.
Choose one of the following options for the
Instance Value
:
Expose as mapping parameter
Create a mapping parameter with the same attributes as the mapplet parameter. Bind the mapping parameter to the mapplet parameter in the same step.
Parameter
Bind a mapping parameter to the mapplet parameter. You can browse for and select a mapping parameter to bind to the mapplet parameter. You can also create a mapping parameter and bind it to the mapplet parameter . When you create a mapping parameter and bind it, you are performing the same task as the
Expose As Mapping Parameter
option. However, when you manually create the mapping parameter, you can configure it with a different name and default value than the mapplet parameter.
Use default
Use the default value from the mapplet parameter. Skip binding a mapping parameter to the mapplet parameter.
Value
Enter a default parameter value to use in the mapping. Skip binding a mapping parameter to the mapplet parameter.

0 COMMENTS

We’d like to hear from you!