Linking Ports - Informatica

You can manually link ports, or you can automatically link ports between transformations. When you link ports automatically, you can link by position or by name. When you link ports automatically by name, you can specify a prefix or suffix by which to link the ports. Use prefixes or suffixes to indicate where ports occur in a mapping. For example, a mapping includes a port in the Source Qualifier called Name and a corresponding port in a Filter transformation called FilName. ‘Fil’ is the prefix you specify when you automatically link ports between the Source Qualifier and Filter transformation.

Manually Linking Ports

To link ports manually, click Layout > Link Columns. When you drag from one port to another, the Designer creates a connection. When you drag a port into an empty port, the Designer copies the port and creates a connection.

You can also link multiple ports at the same time. Use the Ctrl or Shift key to select a range of ports to link to another transformation. The Designer links the ports, beginning with the top pair. It links all ports that meet the validation requirements.

Linking Ports by Position

When you link by position, the Designer links the first output port to the first input port, the second output port to the second input port, and so forth. Use this option when you create transformations with related ports in the same order. Use the following options to link by position:

  • Autolink dialog box. To automatically link ports using the Autolink dialog box, click Layout > Autolink.
  • Autolink command. To link ports by selecting the ports in the workspace, click Layout > Autolink by Position.

Linking Ports using the Autolink Dialog Box

To link ports by position using the Autolink dialog box:

  1. Click Layout > Autolink.
  2. Select the transformations and targets.
  3. You can select multiple transformations in the To Transformations list to link one transformation to multiple transformations. For objects that contain multiple input groups such as Custom transformations or XML targets, select the group name from the To Transformation list.

    You can also select the transformations in the workspace in the order you want to link them. Then, in the Autolink dialog box, select each From Transformation and the Designer selects the To Transformation based on the order in which you selected it in the workspace. Click Apply and then select the next From Transformation and click Apply.

  4. Select Position.
  5. Click OK.
  6. The Designer links the first output port to the first input port, the second output port to the second input port, and so forth.

Linking Ports Using the Autolink by Position Command

To link ports by position using the Autolink by Position command:

  1. Click Layout > Autolink by Position.
  2. Select the mapping object that you want to link by position and drag the selected ports to another mapping object.
  3. The Designer selects all of the ports in an object. To select only specific ports, use the Autolink dialog box.

  4. The Designer links the first output port to the first input port, the second output port to the second input port, and so forth.
  5. When you finish linking ports, click Layout > Link Columns.

Linking Ports by Name

You can link ports by name in the Designer. The Designer adds links between input and output ports that have the same name. Linking by name is not case sensitive. Link by name when you use the same port names across transformations. The Designer can link ports based on prefixes and suffixes that you define. Link by name and prefix or suffix when you use prefixes or suffixes in port names to distinguish where they occur in the mapping or mapplet. Use the following options to link by name:

  • Autolink dialog box. To automatically link ports by name, link ports by name and prefix, and link ports by name and suffix using the Autolink dialog box, click Layout > Autolink.
  • Autolink command. To link objects by selecting the ports in the workspace, click Layout > Autolink by Name.

Linking Ports by Name using the Autolink Dialog Box

To link ports by name using the Autolink dialog box:

  1. Click Layout > Autolink.
  2. Select the transformations and targets.
  3. You can select multiple transformations in the To Transformations list to link one transformation to multiple transformations. For objects that contain multiple input groups such as Custom transformations or XML targets, select the group name from the To Transformation list.

  4. Select Name.
  5. Click OK.

Linking Ports by Name and Prefix/Suffix using the Autolink Dialog Box

To link ports by name and prefix or suffix using the Autolink dialog box:

  1. Click Layout > Autolink.
  2. Select the transformations and targets.
  3. You can select multiple transformations in the To Transformations list to link one transformation to multiple transformations. For objects that contain input groups such as Custom transformations or XML targets, select the group name from the To Transformation list.

  4. Select Name.
  5. Click More to view the options for entering prefixes and suffixes.
  6. In From Transformation, enter the prefix or suffix used in the ports from which you are linking.
  7. In To Transformation, enter the prefix or suffix used in the ports to which you are linking.
  8. In this example, the Designer links ports in SQ_CUSTOMERS to ports in FIL_STATE where the port name in FIL_STATE is either the same as SQ_CUSTOMERS, or is the same and is preceded by the prefix “F_”.

  9. Click OK.

Linking Ports by Name Using the Autolink by Name Command

To link ports by name using the Autolink by Name command:

  1. Click Layout > Autolink by Name.
  2. Select the mapping object that you want to link by name and drag the selected ports to another mapping object.
  3. The Designer selects all of the ports in an object. To select only specific ports, use the Autolink dialog box.

  4. The Designer adds links between input and output ports that have the same name, regardless of name case.
  5. When you are finished linking ports, click Layout > Link Columns.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics