File

The File menu contains options to close the DAC client and to create, copy, or delete source system containers. For instructions on creating or copying a source system container, see Creating or Copying a Source System Container.

Views

The Views menu allows you to navigate to the various tabs in the top pane window.

Tools

The Tools menu provides access to functionality related to the DAC and Informatica repositories. Table 2 provides a description of the Tools menu commands.

Help

The Help menu provides details about the current DAC login as well as the version of DAC metadata and software. There is no online help for the DAC.

DAC Repository Management > Export

Allows you to export the DAC metadata, in XML format, based on the source system container, in order to back up the metadata or to reproduce the environment elsewhere. In the Export dialog box, you can specify a directory in which to store the XML file or accept the default directory, which is DAC\export.

In the Export dialog box, you can select the following category options:

• Logical. Exports all information contained in the Design view and database connection information.
• Run Time. Exports all information contained in the Execute view.
• System. Exports all information contained in the Setup view, except passwords for servers and database connections.

DAC Repository Management > Import

Allows you to import the DAC metadata for the source system containers you specify.

In the Import dialog box, you can specify the following:

• Import/Export folder. A directory from which to import the data. The default directory is DAC\export.
• Truncate repository tables. Indicates whether you want to truncate the repository tables. If you select this option, the existing metadata is overwritten.
• Enable batch mode. Indicates whether batch mode is enabled, which inserts the imported metadata into the repository as an array insert.

In the Import dialog box, you can select the following category options:

• Logical. Imports all information contained in the Design view and database connection information.
• Run Time. Imports all information contained in the Execute view.
• System. Imports all information contained in the Setup view, except passwords for servers and database connections.

DAC Repository Management > Create Repository Report

Allows you to generate a DAC repository report based on the following criteria:

• Table Row Counts
• Object References by Entity
• Ownerless Objects
• Unreferenced Objects
• Dead References

The Clean Up command removes unused referenced objects.

DAC Repository Management > Purge Run Details

Allows you to purge completed runs from the run history. You can purge all runs (except the last run) or specify particular runs to be purged. The last run cannot be purged.

In the Purging Runs... dialog box, the following options are available:

• All. Purges all completed runs except for the last run.
• By Execution Plan. Allows you to select an execution plan whose associated runs you want to purge.
• By Run Name. Allows you to select an individual run for purging.
• Before Specified Date. Allows you to select a date before which all runs except the last run will be purged.
• Details Only. Purges all related information about a run but leaves the run header information.

DAC Repository Management > Analyze Repository Tables

Allows you to run analyze table commands for all the DAC repository tables.

DAC Repository Management > Default Index Properties

Allows you to specify which databases will be associated with newly created indices.

DAC Repository Management > Drop DAC Repository

Allows you to drop all the DAC repository tables. This action deletes all data in the repository.

DAC Server Management > Get Server Log

When the DAC server is running an ETL process, this command opens a text box that displays streaming data related to the process.

DAC Server Management > DAC Server Setup

Allows you to configure the DAC server connections and server email settings. This action should be performed on the machine where the DAC server is running.

ETL Management > Configure

Opens the Data Warehouse Configuration wizard, which allows you to create and drop data warehouse tables and to create delete triggers.

ETL Management > Reset Data Warehouse

Clears the refresh dates for all source and target tables. This action forces a full load to occur.

Seed Data > Task Phases

Allows you to add, edit, or delete task phases.

Seed Data > Task Folders

Allows you to add, edit, or delete task folders.

Seed Data > Logical Data Sources

Allows you to add, edit, or delete logical data sources.

UI Styles > Windows (MFC)

Changes the user interface to the Windows style.

UI Styles > UNIX (MOTIF)

Changes the user interface to the UNIX style.

UI Styles > Java (METAL)

Changes the user interface to the Java style.