Source 

Changes the editor display to show the Java source code of the collaboration. 

Design 

Changes the editor display to show a graphical representation of the collaboration. 

Expand All Graph Objects 

Expands the tables and graphical elements displayed on the editor to show all mapping elements and fields. This is the default view. 

Collapse All Graph Objects 

Collapses the tables and graphical elements displayed on the editor, making it easier to view the different components of the collaboration. 

Toggle Output View 

Toggles between a full-screen pane and a divided pane that shows output messages, like log entries, validations, source and target table data, SQL code, and rejected rows. 

Drop and Recreate Tables 

Drops all source and target database tables and then recreates them. 

Refresh Metadata 

Refreshes the metadata for the source and target tables. 

Select Source and Target Tables 

Enables you to select source and target tables to be used in the collaboration. 

Create New Join 

Launches the Create New Join View dialog box, where you can define source table relationships, or joins. The Create New Join View dialog box also appears when you do either of the following:

• Map a specific source table column to a target table that is already mapped to a different source table, and the two source tables are not already joined.

• Connect a specific source table column to an operator (such as concatenate) that is already connected to a different source table, and the two source tables are not already joined.

Edit Database Properties 

Enables you to configure database OTDs to point the database URL to a different location for design time. This is a temporary setting for design time only; the setting is not saved with the OTD for runtime. 

Add/Edit Runtime Inputs 

Allows you to add input variables to the collaboration. Input variables that are assigned by an external system, such as through a business process, are called runtime inputs. 

Add/Edit Runtime Outputs 

Enables you to add runtime output variables to the collaboration. 

Zoom In, Zoom Out, and Scale 

Changes the scale of the objects in the collaboration. You can zoom in and out, and you can specify a scale percentage. 

AutoLayout All Graph Objects 

Automatically arranges all ETL Collaboration Editor window components. 

Validate Collaboration 

Validates the mapping logic without executing the project. 

Run Collaboration 

Executes the project and generates a message log that displays messages and errors if the execution fails.