Bookshelf: Menu Bar of the DAC

The menu bar is located in the upper-left corner or the DAC window. It consists of the File, Views, Tools, and Help menus.

File Menu

Views Menu

The Views menu provides access to each of the views available in the DAC. The main menu options are Design, Setup, and Execute. These are the same options that are available in the toolbar.

Tools Menu

The Tools menu provides access to various tools you can use to manage and monitor the DAC repository, DAC server, and ETL process.

Table 16. DAC Tools Menu Commands
Tools Menu Command	Description
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 and is stored in the DAC\export directory. 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 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 > 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.

Help Menu

The Help Menu provides access to two dialog boxes: the Login Details dialog box, which contains login information; and the About DAC Client dialog box, which contains the DAC version number.