To Join Source Tables During Mapping

If two source tables are already joined and have columns that are mapped to a target table, you can add another source table to the join by mapping a column in that table to the target table. For example, if source tables S1 and S2 are joined and mapped to target table T1, you can add source table S3 to the join by mapping a column from S3 to T1.

1. Map a columns from the source target you want to add to the join to the target table that is already mapped to the joined tables.

   A dialog box appears asking whether you want to add the new table to the join.

   

2. Click OK to add the new source table to the existing join view.

   The Edit Join View dialog box appears.

   

3. Click in the second join box in the Preview panel.

4. Define the join conditions by dragging columns and operators onto the canvas.