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

Run-time Link Configuration

Run-time Link Configuration

Configure run-time link properties to determine which ports to link between mapping objects at run time. You can define a parameter or select link policy or use both to determine which ports to link.
Use the
Run-time Linking
dialog box or the
Run-time Linking
tab to configure run-time link properties.
The following image shows the
Run-time Linking
tab of the Write transformation:
The Run-time Linking tab has Links and Link Properties area. The Links area lists the group ports from which the link originates if the transformation has incoming run-time links. The Link Properties area has options to configure the run-time link properties based on a parameter, link policy, or both.
At run time, the Data Integration Service establishes and resolves links between the ports in the following order:
  1. Links that you manually create in the mapping editor.
  2. Links based on the parameter that you configured for a run-time link.
  3. Links based on the link policy that you configured for a run-time link.
Configure the following properties for run-time links:
Choose the transformations
In the
Links
area, click the
New
button and select the transformation from which you want to link the ports at run time in the New Link dialog box. The
Links
area lists the group ports from which the link originates if the transformation has incoming run-time links.
Configure a parameter
Use a parameter when the port names can change between mapping runs and you know the port name values. Use a parameter of type Input Link Set to connect ports by name values between mapping runs.
For example, you create a parameter named
Cust_InputLinkSet
of type new Input Link Set and provide the default value as follows:
C_Name -> Cust_name
. At run time, Data Integration Service creates a link between the ports
C_Name
and
Cust_name
. You can change the values of the parameter for the next mapping run as follows:
CustFirstName -> Cust_name
Configure the link policy
A link policy links any unlinked ports by name. When you define target columns by mapping flow, the mapping propagates all ports from the source or from upstream objects. Use a run-time linking policy to propagate ports of certain types or with certain names. Select the link policy when the ports have matching names. Use the link policy when you want to automatically link ports that have matching names.
You can configure the link policy to ignore a suffix or a prefix in the port names. For example, if you configure the link policy to ignore the suffix "_OUT", the Data Integration Service links SALARY_OUT to SALARY.
The linking properties appear in the
Run-time Linking
dialog box or on the
Run-time Linking
tab in the
Properties
based on the action you take to link the groups:
  • Press Ctrl and drag the group from an upstream transformation to a group in the downstream transformation to open the
    Run-time Linking
    dialog box.
  • If you cannot create dynamic ports, you can drag a group from an upstream transformation. Then, select
    Create Run-time Link
    in the
    Linking
    dialog box to open the
    Run-time Linking
    dialog box.
  • Select the
    Run-time Linking
    tab in the
    Properties
    view of the downstream transformation.

0 COMMENTS

We’d like to hear from you!