The following enhancements have been made to Quick ETL Copy:
The Quick ETL Copy dialog box opens, as shown in the following image.
The following options are available:
The application directory where the target tables and generated flow will be stored.
Use the drop-down menu to select a database configured as an adapter.
Use the drop-down menu to select a connection for the selected adapter.
The synonym name for the target table. By default, this is the same name as the source table unless the Application directory is the same, in which case _t is added to the name.
The name of the target table name in the database. By default, this is the same name as the source table, unless the Adapter and Connection are the same as the source in which case _t is added to the name.
Specifies the method used to load data. Select Insert Records from Memory, Load with Aggregations, Bulk Load Utility via Disk File, or Extended Bulk Load Utility if the database supports any of these options.
The number of parallel flows to run simultaneously for parallel processing. This option is only available if the source table has one or more numeric columns as key.
The field to use to partition the table. This option is only available if the source table has one or more numeric columns as key.
This option is only available when the source is a cluster join for a Star Schema. It is useful when copying to Hyperstage or another column-oriented database. Although a single table is created from the joined structure, the synonym retains the structure of the source so that existing procedures that reference the table can continue to be used.
The options are All or Manual. If Manual is selected, an additional dialog box opens which allows you to select which columns are copied.
The dialog box that opens allows you to select which columns are copied. You can drag and drop fields from the Segments/Fields pane on the left to specific folders in the Columns/Filters pane on the right. The options are:
In addition to copying the actual data, metadata elements from the source synonym are copied to the new synonym for the target. These include Defined fields, Filters, and Variables.
When Bulk Load Utility via Disk File or Extended Bulk Load is used, additional parameters are available.
If Select Columns was set to Manual, select the check boxes of the columns you want to copy.