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

Overriding Non-Reusable Transformation Parameters in a Reusable Mapplet

Overriding Non-Reusable Transformation Parameters in a Reusable Mapplet

When you create a reusable mapplet that contains a non-reusable transformation, the transformation remains non-reusable. If you create a non-reusable transformation in a mapplet, the transformation parameters are mapplet parameters. When you add a reusable mapplet that contains a non-reusable transformation to a mapping, the non-reusable transformation in the mapplet remains a non-reusable transformation in the mapping.
You can expose the mapplet parameters as mapping parameters. When you expose the mapplet parameters, the mapplet parameters bind to mapping parameters, and the non-reusable transformation parameters become mapping parameters.
To override the reusable mapplet parameters, complete one of the following tasks:
  • Configure mapping parameters.
  • Expose the mapplet parameters as mapping parameters. After you expose the mapplet parameters, the mapplet parameters use the default values of the mapping parameters at run time. Reconfigure the mapping parameters.
  • Expose the mapplet parameters as mapping parameters. After you expose the mapplet parameters, the mapplet parameters use the default values of the mapping parameters at run time. Configure a parameter set or a parameter file to override the mapping parameters.
To override the non-reusable transformation parameters, complete one of the following tasks:
  • Reconfigure the mapplet parameters.
  • Expose the mapplet parameters as mapping parameters. After you expose the mapplet parameters, the non-reusable transformation parameters become mapping parameters. Reconfigure the mapping parameters.
  • Expose the mapplet parameters as mapping parameters. After you expose the mapplet parameters, the non-reusable transformation parameters become mapping parameters. Configure a parameter set or a parameter file to override the mapping parameters.

0 COMMENTS

We’d like to hear from you!