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

Using a Parameter as a Target for a Dynamic Mapping

Using a Parameter as a Target for a Dynamic Mapping

You can use a parameter as the data object for the transformation and then change the parameter at run time.
  1. Select the Write transformation in the mapping editor.
  2. In the
    Properties
    view, click the
    Data Object
    tab.
  3. Select
    Parameter
    in the
    Specify by
    list.
    In the Data Object tab, you can specify a value or a parameter as the data object.
  4. Select one of the following options:
    • Click
      New
      to create a parameter. Name the parameter, and then browse to select a default value for the parameter.
    • Click
      Browse
      to select an existing parameter.
The following image shows a transformation with a parameter as a data source: When you specify a parameter as a data object, you can view the description and default value in the Data Object Properties view.

0 COMMENTS

We’d like to hear from you!