Create a run-time link between transformation groups to link ports at run time based on a parameter or a link policy or both.
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.
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.
To create a new parameter of Input Link Set type, perform the following steps:
Click
New
.
In the
Parameters
dialog box, enter a parameter name.
For example,
Cust_InputLinkSet
.
Optionally, enter a parameter description.
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
Click
OK
.
To choose an existing parameter of Input Link Set type, perform the following steps:
Click
Browse
.
In the
Assign Parameter
dialog box, choose a parameter.
Optionally, create new parameters or edit parameters from this dialog box.
Click
OK
.
Optionally, to add another run-time link from the
Run-time Linking
dialog box, perform the following steps:
Click the
New
button (
) in the
Links
area.
The
New Link
dialog box appears.
Choose a group from another transformation in the dynamic mapping.
Click
OK
to create a run-time link.
The Developer tool creates run-time links between the groups.
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.