Copy String

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

Paste String

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

Copy Record

Creates a copy of the selected record, with a unique record ID. 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. When you copy a subject area, the tables are also copied but the tasks are not copied. You need to use the Assemble command to reassemble the subject area and add tasks to it.

In the Design view Indices tab and Setup and Execute views, Copy Record copies only the selected record.

Delete

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

NOTE:  When you delete a column from a table, the column is not automatically deleted from the index. You must manually delete columns from indices that were deleted from a table or else the ETL process will fail.

NOTE:  The DAC does not display deleted objects. You must look at the database to figure out what objects were deleted.

Output to File

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

Record Info

Displays the record's unique ID, object type, current source system, owner source system, and the timestamp for when it was last updated. It also displays the source system lineage and the source systems that reference the object.

Update Records

For some columns, allows you to update the column value for each row to a single value.

Ownership

• Reference. Opens the Reference dialog box, which allows you to reference objects from one container to another. The reference function works like a symbolic link or shortcut.
• Re-Reference. If an object is a referenced object, that is, a reference to an object in another container and a change is made to the original object's child objects, you can use this command to import the changes to the referenced object.
• Push to References. If an original object is changed, you can use this command to export the changes to all referenced objects' child objects.
• De-Clone. When you make changes to a referenced object, the new object is called a clone. This command allows you to revert a cloned object back to its state as a reference.
• Re-Assign Record. This command allows you to reassign an objects ownership.

For more information about the ownership of objects, see About Object Ownership in the DAC.

Assemble

Assembles a subject area, with dimension and related tables as well as tasks.

Generate Index Scripts

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.

Change Capture Scripts

• Image and Trigger 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.
• View Scripts. 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.
• Change Capture SQL. 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.

Import from Database

• Import Database Tables. Allows you to import table definitions from a selected database. This action does not import columns.
• Import Indices. Allows you to import index definitions from a selected database for one or more tables as listed in the result of the query.
• Import Database Columns. Allows you to import column definitions from a selected database.

Filter Indices

Allows you to filter by database type the indices that are displayed in the top pane list.

Output Task Description

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

Synchronize Tasks

Synchronizes the information the DAC has for a task's source and target tables with the information in the Informatica repository.

Flat Views

Opens a dialog box that allows you to query for various objects, modify data, and do mass updates.

You can query for the following objects:

Tables tab:

• Related Tables
• Table Columns

Indices tab: Index columns

Tasks tab:

• Task Source Tables
• Task Target Tables
• Task Conditional Tables
• Task Phase Dependencies
• Task Parameters

Test Connection

In the Physical Data Sources tab, it allows you to test the database connection.

In the Informatica Servers tab, it allows you to test the connection to the Informatica Server and Repository Server.

The DAC server performs this command if the DAC client is connected to a server. If the DAC client is not connected to a DAC server, then the DAC client performs the command.

Mark as Completed

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.

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.