This section provides information about the Join component.
Drag and drop the Join component on the canvas to link multiple entities such
as EDDs (Insert Connector)/ADIs (Extract Connector).
To position the component on the canvas, drag and move the component, or click
the component and use arrow keys on the keyboard to move it around.
Join accepts input from two entities.
To join more than two entities, drag another Join component. Link the output of
the first join to the input of the second join and then connect the other
entities. You can repeat this for multiple entities. Select the source entity
and click Ok.
At any given time, right-click the component and select the relevant options to
either delink, remove inlinks or outlinks, or delete the component.
Double-click the Join component to define a join condition. The selected
entities are displayed on the left and right tabs.
You can drag and reorder the left and right tab to choose the right/left entity
in a join condition.
To join entities, the select a column from the left, select a column from the
right tab and click = (Add Join). This displays the joined entities. You can
join multiple entities.
To remove two joined conditions, select the two columns from the left and right
tabs, and click Remove Join. The joined condition is removed from the
list.
Click Reset to reset all the joined conditions.
Click Ok.
Note:
This creates an inner join
between the connected EDDs.