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

How to Configure Parameters

How to Configure Parameters

Define parameters in a transformation, a mapping, a mapplet, or a workflow.
The following image shows the process to use parameters in a reusable transformation in a mapping:
  1. In a reusable transformation, create a parameter for a property in the transformation or for a variable in the Expression Editor.
  2. Add the transformation to a mapping or to a mapplet.
  3. In the transformation
    Parameters
    tab, choose how to set the parameter value in the mapping or the mapplet.
    • Expose the transformation parameter as a mapping parameter. Creates a duplicate of the transformation parameter at the mapping level.
    • Bind the transformation parameter to a mapping parameter. Browse for a mapping parameter or manually create a mapping parameter to bind to the transformation parameter.
    • Enter a specific parameter value. Enter a default value to use in the mapping run.
    • Use the default value of the transformation parameter. Use the original parameter value in the mapping.
    After you bind a mapping parameter to the transformation parameter, you can createa parameter set or a parameter file to override the mapping parameter value at run time. Run the mapping from the Developer tool or the command line. Specify the parameter set or parameter file to use for the mapping run.

0 COMMENTS

We’d like to hear from you!