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

Parameter Instance Value

Parameter Instance Value

When you add a reusable transformation with parameters to a mapping, you can configure the instance value for each parameter in the transformation.
The instance value is the parameter value for a specific mapping. You can set the instance value to a default value, a specific value, or to a mapping parameter value.
A mapping parameter or a mapplet parameter can override the default value of the transformation parameter. Select a mapping parameter or a mapplet parameter and bind the parameter to the transformation parameter.
Set the instance value on the transformation
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 transformation parameter and bind the mapping parameter to the transformation parameter in the same step. If you click the
Expose as Mapping Parameter
button a second time, and the transformation parameter is already bound to mapping parameter, the Developer tool does not change the mapping parameter.
Parameter
Browse for and select a mapping parameter to bind to the transformation parameter. You can also create a mapping parameter and bind it to the transformation parameter. When you create the 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 a different name than the transformation parameter.
Use default
Use the default value from the transformation parameter. Skip binding a mapping parameter to the transformation parameter.
Value
Enter a default parameter value to use in the mapping. Skip binding a mapping parameter to the transformation parameter.

0 COMMENTS

We’d like to hear from you!