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. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Binding Parameters to Override the Parameters at Run Time

Binding Parameters to Override the Parameters at Run Time

When you add a reusable object to a mapping or workflow, bind parameters to higher-level parameters in the parameter hierarchy to override the default value of the reusable object parameter. At run time, the Data Integration Service applies the higher-level parameter to the reusable object.
For example, you create a reusable transformation and a parameter in the transformation. Then you add the reusable transformation to a mapplet. You can either use the default parameter value from the transformation, or you can bind the transformation parameter to the mapplet parameter. Change the default value for the mapplet parameter to override the default value of the transformation parameter at run time.
To bind user-defined parameters, expose the parameters. For example, if you add a reusable transformation to a mapping, expose the transformation parameters as mapping parameters to bind the transformation parameters to the mapping parameters.
The following image demonstrates how the Data Integration Service binds parameters in Developer tool mappings:
This image shows a diagram of a mapping that contains a transformation, Transformation 1, and a mapplet. The mapplet contains a second transformation, Transformation 2. The mapping has two parameters, Parameter A and Parameter B. Transformation 1 contains one parameter, Parameter C. The mapplet contains one parameter, Parameter D, and Transformation 2 within the mapplet contains a parameter, Parameter E. Parameter E is connected to Parameter D through an arrow. Parameter D is conntected to Parameter A with an arrow. Parameter C is connected to Parameter B with an arrow.
  1. The parameter in the transformation binds to the parameter in the mapplet. The transformation parameter uses the default value of the mapplet parameter at run time.
  2. The parameter in the mapplet binds to the parameter in the mapping. The mapplet parameter uses the default value of the mapping parameter at run time.
  3. The parameter in the transformation binds to the parameter in the mapping. The transformation parameter uses the default value of the mapping parameter at run time.

0 COMMENTS

We’d like to hear from you!