9.6 Use Auto-join to Map Associated Tables in a Data Flow

You can use the auto-join feature to establish join conditions between tables based on predefined relationships, such as primary key/foreign key relationships or common column names.

To use auto-joins in a data flow:

1. Follow the instructions in Create a Data Flow to create a new data flow.
2. In the Data Flow Editor click Add a Schema to define your source connection.
3. Drag the table that has the foreign key and drop it on the design canvas.
4. Select the object on the design canvas, and click the icon.

   The Join Data Entity page appears listing the tables where the foreign key of this table references the primary key of another table.

5. Select the table(s) you want to use and click Save. This will automatically create the join condition.
6. Save and execute the data flow.

   Data Transforms will join the tables and insert the matching records into the target table.