Defining a Table Join
On the Dimension Table Joins form, use these steps to define the table joins:
- At the top of the form, specify the name of the object that these table joins describe. Also specify the base table name, alias and primary key. The base table is the principal table to which other tables will be joined. Be aware that there are more than 200 records in some of these drop-down lists, so use a partial name with a wild card to filter the list results.
-
Next, specify the name and alias of a table to be joined. Also
specify the type of table join that this table has in relation to
the base table:
- Primary Table: An additional table that has a one-to-one relationship with the base table.
- Secondary Table: An additional table that has a one-to-many relationship with the base table.
- In the Join Type field, specify how secondary tables are joined to other tables. Specify Inner Join only if the columns referenced in the join are not nullable and the join is on a foreign key. Otherwise, use Outer Join.
- Select the column in the current table to use as the join, and the other table and column to join it to. The other table must already be listed in this form.
- Click Add to display the join information in the text box and in the Join Text area of the grid.