Table 30. DAC Toolbar and Right-Click Menu Commands
|
|
|
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. |