Bookshelf: About the DAC Tables Tab

The Tables tab displays a list of tables in the top pane. This list includes the following information shown in Table 22.

Table 22. DAC Tables Tab List Columns
Column	Description
Name	Name of table.
Table Type	Indicates the type of target table. There is no differentiation for source tables.
Image Suffix	Applicable to Siebel source tables only. For more information, see Change Capture Scripts Command.
Inactive	Indicates whether a table is active or inactive. Inactive tables do not participate in the ETL process.

Table 23. DAC Tables Subtabs
Tab	Description
Edit	Allows you to edit the table selected in the top pane.
Description	Displays a description of the table selected in the top pane.
Database Connections	Displays a list of data sources associated with the table selected in the top pane. The Edit button allows you to add or remove data sources.
Indices	Displays a read-only list of indices that belong to the table selected in the top pane.
Source for Tasks	Displays a read-only list of tasks that use the table selected in the top pane as a source.
Target for Tasks	Displays a read-only list of tasks that use the table selected in the top pane as a target.

Actions Available

The following actions are available in the top pane toolbar and in the right-click menu when the Tables tab is active.

Copy Record

This command creates a copy of the selected table and also copies the references to database connections.

Generate Index Scripts Command

This command generates drop index, create index, and analyze table scripts for all the tables that participate in the ETL process. You can query for one or more tables, and the command will generate all the scripts for all the tables. The results are stored in the log\scripts directory. Files are generated that provide the following information: drop indices of type ETL, create indices of type ETL, drop indices of type Query, create indices of type Query, and analyze tables.

Change Capture Scripts Command

This command generates change capture scripts for tables with defined image suffixes. The scripts include creation of the image tables to assist in the change capture process and their indices. You can also create the triggers for deletes. However, you should do so with caution because preconfigured tables for the change capture are created by applying SIF files on the Siebel OLTP. Triggers for deletes should be used only for new source tables for which you want to use change capture. The scripts will be generated for the selected table or all the tables shown in the list applet. You can narrow down the tables of interest by querying. The results are shown in a text box, which can be supplied to the DBA for executing.

Import Database Tables Command

This command allows you to import table definitions from a selected database. You will be prompted to choose a database connection from a list that has already been defined in the DAC repository. When this command is executed, a list of tables in the data source is shown in a list applet. Check the Import flag in the list applet to select the tables that you want to import. The tables are then brought into the DAC repository. The default table type associated with the newly imported tables is Other. After you import the tables, change the table type to the appropriate type and associate the table with a database connection.

Import Indices Command

This command allows you to import index definitions from the database for one or more tables as listed in the result of the query. You will be prompted to select a data source. The client connects to the database and retrieves the index definitions for the table. The list includes new indices that may have been created in the database, indices whose definitions are modified in the database, or indices that do not exist in the database. To accept the changes, check the Merge? check box. When you select the list to be merged, one of the following actions will take place: If an index definition does not exist in the DAC repository, it will be created; if an index definition exists but the definition is the same, the new definition will be brought in; or if an index as defined in the repository does not exist is the database, it will be inactivated.

NOTE: In MSSQL Server databases, when you import indices with columns whose sort order type is "Desc," the sort order type appears in the DAC as "Asc." You have to set the sort order manually to "Desc."