How to: |
The Quick ETL Copy option generates a simple Data Flow without using the Data Flow designer. For the selected table(s), all rows and columns are copied to new table(s).
Although no transformations or WHERE conditions are generated, the Data Flow can still be opened as such and additional criteria can be added.
The Quick ETL Copy dialog box opens, as shown in the following image.
The synonym name for the target table.
The name of the target table in the database.
Select a database configured as an adapter from the drop-down menu.
Select a connection for the selected adapter from the drop-down menu.
Specifies the method DataMigrator uses to load data. Select Insert Records From Memory or Bulk Load Utility via Disk File if the database supports either of these options.
Specifies the commit interval. This option is only available if the Load Type is set to Insert Records From Memory.
Specifies the number of rows to be inserted at a time. This option is only available if the Load Type is set to Insert Records From Memory.
The application directory where the target tables and generated flow will be stored.
The Quick ETL Copy for Sources in dialog box opens, as shown in the following image.
The Quick ETL Copy - Creating the flow dialog box opens and lists all of the synonyms that you selected.
WebFOCUS |