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

Parameters in Mappings

Parameters in Mappings

You can assign parameters to mapping properties, or you can create parameters for mapping objects.
When you define a mapping parameter, you can bind the mapping parameter to a transformation parameter. The mapping parameter value overrides the default parameter value in the transformation.
When you bind a mapping parameter to a transformation parameter, the parameters must be the same type. The mapping parameter name does not have to be the same as the transformation parameter name.
You can use a parameter set or a parameter file to set the mapping parameter values at run time. You cannot set reusable transformation, reusable mapplet, or reusable data source parameter values with a parameter set or parameter file. To change parameter values in reusable objects at run time, expose the parameter values as mapping parameters. Configure mapping parameters for the exposed values in the parameter set or parameter file.
Use one of the following methods to define mapping parameters:
Define mapping parameters on the
Parameters
tab of the mapping
Properties
view
On the mapping
Parameters
tab, you can manually enter each parameter name, the parameter attributes, and the default value. You can bind these parameters to transformation parameters whenever you add a transformation to the mapping. You can update the mapping parameters on the mapping
Parameters
tab. You can also view and access the parameter in the Outline view.
Add mapping parameters from reusable transformation parameters
After you add a transformation to a mapping, you can create a mapping parameter directly from the transformation
Parameters
tab. To create a mapping parameter from the transformation parameter, expose the transformation parameter as a mapping parameter. The Developer tool creates a mapping parameter that has the same name and type as the transformation parameter.
Add parameters to a non-reusable transformation
If you create a transformation in a mapping, the transformation is a non-reusable transformation. If you parameterize any of the transformation properties, you create mapping parameters instead of transformation parameters. The mapping parameters bind to the transformation parameters.

0 COMMENTS

We’d like to hear from you!