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.