Selecting Data for Partial Joins

For a partial outer join, you must select the table(s) for which incomplete records will be retained. For example, you may want to retain all records from a Customer table while retaining only matched records from the Mortgage Loan table.

To select datasets for partial joins:

1. Click the Merge tab of the Merge node.
2. Select Include matching and selected non-matching records (partial outer join).
3. Click the Select button to open a dialog box where you can specify datasets for the partial join.

Outer Join column. In the Outer Join column, select datasets to include in their entirety. For a partial join, overlapping records will be retained as well as incomplete records for datasets selected here. See the topic Types of Joins for more information.