Table 15. DAC Toolbar and Right-Click Menu Commands
|
|
|
|
Top and bottom pane toolbars, right-click menu |
Creates a placeholder for a new record in the selected list. |
|
Top and bottom pane toolbars, right-click menu |
Saves the current record. |
|
Top and bottom pane toolbars, right-click menu |
Undoes changes made to the current record after the last save. |
|
Top and bottom pane toolbars, right-click menu |
Deletes the selected record. If you delete a parent record, the child records are also deleted. |
|
Top and bottom pane toolbars, right-click menu |
|
|
Top and bottom pane toolbars, right-click menu |
Retrieves the data from the repository with the last used query. |
|
Top pane toolbar in Design view tabs: Execution Plans, Subject Areas, and Table Groups |
Generates a preview of all tasks and their dependencies. |
|
Bottom pane toolbar in Design view |
Opens a dialog box in which you can add and remove objects associated with the selected repository object. |
|
Bottom pane toolbar in Execute view, Task tab |
Provides a list of the task details that are executed when the selected task is run. |
|
Top pane toolbar in Design view, Execution Plans tab |
Starts a new ETL process. |
|
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. |
|
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. |
|
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. |
|
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. |
|
|
Copies the contents of a cell (editable and read-only) to the clipboard |
|
|
Pastes a string from the clipboard into a selected cell that supports a string data type. |
|
|
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. |
|
|
Outputs to a text file in the DAC root folder the contents of the current tab's record list. |
|
|
Displays the record's unique ID and the timestamp for when it was last updated. |
|
|
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 |
|
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. |
|
|
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. |
|
|
Allows you to import table definitions from a selected database. |
|
|
Allows you to import index definitions from the database for one or more tables as listed in the result of the query. |
|
|
Saves to an HTML file the description for a selected task definition or for all task definitions. |
|
|
Starts a new ETL process. |
|
|
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). |
|
|
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. |
|
|
Changes the status of the selected, completed task and its dependents to Queued. Available only for failed ETLs. |
Get Run Information > Get Log File |
|
Fetches the log file for this run from the DAC server and saves it in the ServerLog folder. |
Get Run Information > Analyze Run |
|
Saves a description of the run as an HTML file in the Log/Statistics folder. |
Get Run Information > Get Chart |
|
Displays a chart showing changes in task statuses over time in a separate window. |
Get Run Information > Get Graph |
|
Displays a graph showing changes in task statuses over time in a separate window. |