Add and Define Physical Joins

You can define joins between physical tables in the same data source, or you can define joins between physical tables in different data sources. You use the Physical Diagram to add and define joins.

Semantic Modeler determines what type of join to create based on the selected object types and the join expression.

See About Physical Joins and Use Hints in SQL Statements.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer .
4. Click a table, right click, and select Show Physical Diagram and select Selected Tables Only.
5. Drag and drop additional tables to the Physical Diagram.
6. Working in the Physical Diagram, hover over the first table in the join (the table representing many in the one-to-many join.), grab its handle, and drag to the table that you want to join to (the table representing one in the one-to-many join).
   A box is displayed around the table that you are joining to.
7. In the Add Physical Join dialog box, specify one or more join conditions, or click Use Join Expression to specify the join properties and enter the join expression.
   If using Unknown cardinality, then you only need to select Unknown for one side of the join. For example, choosing unknown-to-1 is equivalent to unknown-to-unknown and appears as such the next time you open the dialog box for this join.
8. Click Add.