Creating a Join
-
On the Create Mapping <logical model name> page,
select the required logical entity, and click the Join
builder icon on the tool bar .
Note: The Transformation panel doesn't display details of the physical model table. In case you click a physical model table after an entity and open the Transformation panel, it displays details of the last selected entity.The Join Builder for logical table <name of the table> pop-up window is displayed.
-
Click the Add table button.
A table is displayed with Left table, Right table, and Join type columns.
- Use the <select table> and <select column> drop-down options of the Left table and Right table columns to specify the columns (of the physical model tables) from which data is to be joined.
-
From the Join type drop-down list, select the type of
join you want between the columns. The options are:
- Inner join: Returns matching records between the selected left and the right table columns.
- Left join: Returns all records from the left column, in addition to any matching records from the right column.
- Right join: Returns all the records from the right column, in addition to any matching record from the left column.
- Full outer join: Returns all the records from the left and the right columns.
-
To establish joins on multiple columns of the table, hover cursor over the
table row, and click the Add comparison icon that appears.
A new <select column> row is displayed.
- Repeat steps 4 and 5 to define the join criteria.
-
To establish join between another set of tables, click the Add
table button.
Note: You need to have the set of table dragged on to the canvas to be able to establish join between those.A new set of <Select table> and <Select column> rows are displayed.
- Repeat steps 3 and 4 to define the join.
- Click OK.
Note: Joins are not represented by any physical link between the tables on the
canvas.