Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > DAC Functional Reference > About the DAC Design View >
About the DAC Indices Tab
The Indices tab displays a list of all the indices of all the data warehouse tables. It is recommended that you do not register any indices for source tables. During the ETL process, when a table is going to be truncated, all the indices as defined in the repository will be dropped before the data is loaded and will be created after the data is loaded automatically. While this improves the ETL performance, the preconfigured workflows have the bulk load option turned on. The bulk load will fail if there are indices on the table. Therefore, it is important to keep the index definitions in sync with the database. For example, if you create an index on the database, and it is not registered in the repository, the index will not be dropped and the load will fail.
Table 24 provides a description of the index properties displayed in the list.
Table 25 shows which index properties are available for the different database types that are supported.
Table 26 provides a description of the tabs in the bottom pane.
Actions Available
The following actions are available in the top pane toolbar and in the right-click menu when the Indices tab is active.
Copy Record
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |