New

Top and bottom pane toolbars, right-click menu

Creates a placeholder for a new record in the selected list.

Save

Top and bottom pane toolbars, right-click menu

Saves the current record.

Undo

Top and bottom pane toolbars, right-click menu

Undoes changes made to the current record after the last save.

Delete

Top and bottom pane toolbars, right-click menu

Deletes the selected record. If you delete a parent record, the child records are also deleted.

Query

Top and bottom pane toolbars, right-click menu

Opens a blank query.

Refresh

Top and bottom pane toolbars, right-click menu

Retrieves the data from the repository with the last used query.

Preview

Top pane toolbar in Design view tabs: Execution Plans, Subject Areas, and Table Groups

Generates a preview of all tasks and their dependencies.

Edit

Bottom pane toolbar in Design view

Opens a dialog box in which you can add and remove objects associated with the selected repository object.

Details

Bottom pane toolbar in Execute view, Task tab

Provides a list of the task details that are executed when the selected task is run.

Run Now

Top pane toolbar in Design view, Execution Plans tab

Starts a new ETL process.

Start

Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History

Restarts the selected ETL, after the ETL has failed, stopped, or been aborted.

Stop

Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History

Stops an ETL in progress. All currently running tasks will complete, and queued tasks will stop. The status of the ETL changes to Stopped.

Abort

Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History

Causes an ETL in progress to abort. All currently running tasks will be aborted. The status of queued tasks and the ETL itself will change to Stopped.

Auto Refresh

Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History

Allows you to turn on and off the automatic screen refresh functionality and set the refresh interval.

Copy String

Right-click menu

Copies the contents of a cell (editable and read-only) to the clipboard

Paste String

Right-click menu

Pastes a string from the clipboard into a selected cell that supports a string data type.

Copy Record

Right-click menu

Creates a copy of the selected record, with a unique record ID and (2) appended to its name. The new record is committed to the database when you click the Save button or click outside the cell. In the Design view tabs (except for the Indices tab), Copy Record copies the selected record and the record's child records. In the Design view Indices tab and Setup and Execute views, Copy Record copies only the selected record.

Output to File

Right-click menu

Outputs to a text file in the DAC root folder the contents of the current tab's record list.

Record Info

Right-click menu

Displays the record's unique ID and the timestamp for when it was last updated.

Generate Index Scripts

Right-click menu on Execution Plan and Tables tabs

Generates drop index, create index, and analyze table scripts for all tables that participate in the ETL process. The results are stored in the log\scripts directory.

Generate Change Capture Scripts > Generate Image and Trigger Scripts

Right-click menu on Tables tab

Generates change capture scripts for tables with defined image suffixes. The scripts may include delete triggers, create and drop statements for delete triggers, and image tables and their indices.

Generate Change Capture Scripts > Generate View Scripts

Right-click menu on Tables tab

Generates change capture view scripts for full or incremental mode for tables that participate in the change capture process. This command can be used for unit testing.

Generate Change Capture Scripts > Generate Change Capture SQL

Right-click menu on Tables tab

Generates change capture SQL scripts for full or incremental mode for tables that participate in the change capture process. This command can be used for unit testing.

Update Rows

Right-click menu

For some columns, allows you to update the column value for each row to a single value. When you select this command, a dialog box allows you to select the column, and then a second dialog box allows you to enter a value for the column.

Import Database Tables

Right-click menu

Allows you to import table definitions from a selected database.

Import Indices

Right-click menu

Allows you to import index definitions from the database for one or more tables as listed in the result of the query.

Output Task Description

Right-click menu

Saves to an HTML file the description for a selected task definition or for all task definitions.

Run Now

Right-click menu

Starts a new ETL process.

Go To

Right-click menu

Allows you to drill down to a particular record that is associated with the selected record. Available when the Task Definitions, Indices, Tables, and Table Groups tabs are active (Design View).

Mark as Completed

Right-click menu

Changes the status of a stopped or failed ETL to Completed. In the audit trail for this ETL, the status is Marked as Completed. Use this command with caution; it can cause the data warehouse to be inconsistent.

Requeue Task

Right-click menu

Changes the status of the selected, completed task and its dependents to Queued. Available only for failed ETLs.

Get Run Information > Get Log File

Right-click menu

Fetches the log file for this run from the DAC server and saves it in the ServerLog folder.

Get Run Information > Analyze Run

Right-click menu

Saves a description of the run as an HTML file in the Log/Statistics folder.

Get Run Information > Get Chart

Right-click menu

Displays a chart showing changes in task statuses over time in a separate window.

Get Run Information > Get Graph

Right-click menu

Displays a graph showing changes in task statuses over time in a separate window.