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

Setting the Parameter Instance Value

Setting the Parameter Instance Value

You can set the parameter instance value from the
Instance Value
column on the transformation Parameters tab. Set the instance value in this column if you do not want to create a duplicate mapping parameter.
You can set a transformation parameter to a default value or you can bind an existing mapping parameter to the transformation parameter.
  1. After you add a transformation to a mapping, click the
    Parameters
    tab on the
    Properties
    view of the transformation.
  2. To bind a mapping parameter to a transformation parameter, perform the following steps:
    1. Click the
      Instance Value
      column for the transformation parameter.
      The
      Specify By
      dialog box appears.
    2. Click
      Specify By Parameter
      .
    3. On the
      Assign Parameter
      dialog box, browse for and select a mapping parameter or a system-defined parameter to bind to the transformation parameter.
    4. Click
      OK
      .
      The mapping parameter name appears as the parameter value in the
      Specify By
      dialog box.
    5. Click
      OK
      in the
      Specify By
      dialog box.
      The mapping parameter name appears in the
      Instance Value
      column.
  3. To set a default value for the transformation parameter instance, use the following steps:
    1. Click the
      Instance Value
      column for the transformation parameter.
      The
      Specify By
      dialog box appears.
    2. To enter a default value, click
      Specify By Value
      and enter a default value for the instance.
    3. To use the transformation parameter default value, click
      Use Default
      .

0 COMMENTS

We’d like to hear from you!