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

Creating and Configuring a Run-time Link

Creating and Configuring a Run-time Link

Create a run-time link between transformation groups to link ports at run time based on a parameter or a link policy or both.
  1. Create a run-time link in the following ways:
    • Press Ctrl and drag the group to a downstream transformation in the dynamic mapping.
      The
      Run-time Linking
      dialog box appears.
    • To create a run-time link to a Write transformation or a reusable transformation, drag a group from an upstream transformation to a group in the reusable transformation or a Write transformation. Then, select
      Create Run-time Link
      in the
      Linking
      dialog box to open the
      Run-time Linking
      dialog box.
    • In the downstream transformation to which you want to create a run-time link, go to the
      Properties
      view and click the
      Run-time Linking
      tab.
  2. In the
    Link Properties
    area, select one or both from the following options to determine which ports to link at run time:
    • Parameter
      . Use parameter if the port names can change between mapping runs and you know the port names. You can create a new parameter or choose an existing parameter of type Input Link Set.
    • Link Policy
      . Use link policy to automatically link ports by name. This option is selected by default. If the port names contain a prefix or suffix, enter the string to ignore.
  3. To create a new parameter of Input Link Set type, perform the following steps:
    1. Click
      New
      .
    2. In the
      Parameters
      dialog box, enter a parameter name.
      For example,
      Cust_InputLinkSet
      .
    3. Optionally, enter a parameter description.
    4. Enter a default value for the parameter as comma-separated pairs of ports.
      For example, enter the default value as follows:
      C_NAME->Cust_name, C_ACCTBAL->Cust_acctbal
    5. Click
      OK
      .
  4. To choose an existing parameter of Input Link Set type, perform the following steps:
    1. Click
      Browse
      .
    2. In the
      Assign Parameter
      dialog box, choose a parameter.
    3. Optionally, create new parameters or edit parameters from this dialog box.
    4. Click
      OK
      .
  5. Optionally, to add another run-time link from the
    Run-time Linking
    dialog box, perform the following steps:
    1. Click the
      New
      button ( "" 
					 ) in the
      Links
      area.
      The
      New Link
      dialog box appears.
    2. Choose a group from another transformation in the dynamic mapping.
  6. Click
    OK
    to create a run-time link.
    The Developer tool creates run-time links between the groups.
  7. To edit an existing run-time link, right-click the link, and select
    Run-time Linking
    The
    Run-time Linking
    dialog box appears where you can change the options to determine which ports to link.

0 COMMENTS

We’d like to hear from you!