Edit Join Node

Click the Join tab if it is not displayed. To add a new Join column, click

Add join column

Edit Join Column Dialog launches. Select the Data Sources Source 1 and Source 2. You can search columns in either Source by Name or by Data Type. Select one entry in Source 1 and the corresponding entry in Source 2. Click Add. Data Miner selects an appropriate Join Type.

Column 1 (from Source 1), Column 2 (from Source 2), and the Join type are displayed in a grid. You can search this grid by Column 1, Column 2, or Join Type.

When you are done selecting columns, click OK.

To select the columns in the join, click the Columns tab to display Edit Columns.

To define a filter for the join, select the Filter tab and type in an appropriate SQL expression. You can also use SQL Worksheet (part of SQL Developer) to write a filter.

If there are problems with the join, for example, if one of the join nodes is no longer connected to the Join node, an information indicator is displayed as follows: Join with issues to resolve.

Click the Resolve Issues link to launch the Resolve Dialog.