DAC Repository Management > Export

Allows you to export all or part of the DAC metadata in order to back up the data or to reproduce the environment elsewhere. The seed data is exported in XML format. 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 options:

• Export All Tables.
• Export Categories. The Logical option exports all information contained in the Design view and database connection information. The Run Time option exports all information contained in the Execute view. The System option exports all information contained in the Setup view, except passwords for servers and database connections.
• Export Selected Tables. Allows you to select tables for exporting.

DAC Repository Management > Import

Allows you to import all or part of the DAC metadata. When you import data, any existing data in the repository is overwritten.

If you want to import new DAC metadata while still working on the same data warehouse, you must keep the table refresh dates intact.

In the Import dialog box, you can specify a directory from which to import the data or accept the default directory, which is DAC\export.

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

• Import All Tables.
• Import Categories. The Logical option imports all information contained in the Design view and database connection information. The Run Time option imports all information contained in the Execute view. The System option imports all information contained in the Setup view, except passwords for servers and database connections.
• Import Selected Tables. Allows you to select tables for importing.

DAC Repository Management > Validate Repository

Allows you to start the repository validation process.

DAC Repository Management > Import Informatica Sessions

Allows you to import a list of Informatica workflow names and folders into a staging table in the DAC repository.

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. Note: The last run cannot be purged.

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

• Entire Run History. Allows you to purge all runs and their related information. The data warehouse must be reset for this option to complete successfully.
• 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 you can use to configure an ETL process.

ETL Management > Reset Data Warehouse

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

ETL Management > Preferences

Allows you to configure ETL preferences, such as start and end dates for building the day dimension, currency, language, exchange rate, prune days for disconnected users, maximum number of days an opportunity can spend in a sales stage, and the index space for Oracle databases.

Task Properties > Task Phases

Allows you to add or edit task phases.

Task Properties > Task Folders

Allows you to add or edit task folders.

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.