Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > Working in a Repository's Physical Layer > Physical Layer Objects >
Working with Physical Tables
A physical table is an object in the Physical layer of the Administration Tool that corresponds to a table in a physical database. Physical tables are usually imported from a database or another data source, and they provide the metadata necessary for the Siebel Analytics Server to access the tables with SQL requests.
Object Types
In addition to importing physical tables, you can create virtual physical tables in the Physical layer, using the Object Type option in the Physical Table dialog box. A virtual physical table can be an alias, a stored procedure, or a Select statement. Virtual physical tables have several uses. You can use them to create the equivalent of a database view; that is, the virtual table generated by some query expression. You can use them to behave like a synonym; that is, a table identical to another table but with a different name. You can also use them to define a portion of the domain of a group of fragmented aggregate tables, as described in Define a Physical Layer Table with a Select Statement to Complete the Domain. Creating virtual tables can provide the Siebel Analytics Server and the underlying databases with the proper metadata to perform some advanced query requests.
The Object Type drop-down list in the General tab of the Physical Table dialog box allows you to specify the physical table object type. Table 12 provides a description of the available object types.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 23 June 2003 |