Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Working in a Repository's Physical Layer > About Physical Joins >

Defining Physical Joins with the Joins Manager

---

You can use the Joins Manager to view join relationships and to create physical foreign keys and complex joins.

NOTE:  Primary key and foreign key joins must be created in the Keys tab and Foreign Keys tab of the Physical Table dialog box. See also Defining Physical Joins in the Physical Table Diagram.

To create a physical foreign key or complex join

In the Administration Tool tool bar, select Manage > Joins.

The Joins Manager dialog box appears.

Perform one of the following tasks:
Select Action > New > Complex Join.

The Physical Complex Join dialog box appears.

Select Action > New > Foreign Key. In the Browse dialog box, double-click a table.

The Physical Foreign Key dialog box appears.

Enter a name for the foreign key.
Click the Browse button for the Table field on the left side of the dialog box, and then locate the table that the foreign key references.
Select the columns in the left table that the key references.
Select the columns in the right table that make up the foreign key columns.
If appropriate, specify a database hint.

For information about database hints, see Using Database Hints.

To open the Expression Builder, click the button to the right of the Expression pane.

The expression displays in the Expression pane.

Click OK to save your work.

Bookshelf Home | Contents | Index | Search | PDF