How to add all columns for all input sources (Enterprise Manager)

To add all columns for all input sources

1. Make sure no join lines between input sources in the Diagram pane are selected.
2. Right-click in the query window and choose Properties from the shortcut menu. Then choose the Query tab.
3. Choose Output all columns.

   –or–

   Specify * in the output list of the SQL statement in the SQL pane.