The port names in the target definition are the same as some of the port names in the Source Qualifier transformation. When you need to link ports between transformations that have the same name, the Designer can link them based on name.
In the following steps, you use the autolink option to connect the Source Qualifier transformation to the target definition.
dialog box appears.
Select T_EMPLOYEES in the To Transformations field. Verify that SQ_EMPLOYEES is in the From Transformation field.
Verify Name is selected, and click
The Designer links ports from the Source Qualifier transformation to the target definition by name. A link appears between the ports in the Source Qualifier transformation and the target definition.
To link ports with different names, you can drag from the port of one transformation to a port of another transformation or target. If you connect the wrong columns, select the link and press the Delete key.
dialog box, select the T_EMPLOYEES target, and click
The Designer rearranges the source definition, Source Qualifier transformation, and target definition from left to right, making it easy to see how one column maps to another.
Optionally, to see all columns in the source definition, Source Qualifier transformation, or target definition window, drag the lower edge of the windows until all columns appear.