Notes
|
Any notes or helpful information about this operator's parameter settings. When you enter content in the
Notes field, a yellow asterisk is displayed on the operator.
|
Copy To
|
The database to copy the data set to.
|
Destination
|
The schema to copy the data set to.
|
Table Name
|
The name for the new table.
Default value:
alp@user_id_@flow_id_dbtodb_0.
|
If Table Exists
|
The desired behavior if the table exists in the destination location.
- Append - Append the data to the end of the table.
- Drop (the default) - Drop the table and replace it with the new one.
- Error - Produce an error.
- Skip - Skip this table.
|
Result Table Structure
|
The table structure for the resulting table to which to copy. When the dialog box is opened, if the resulting table exists, the schema is read from the resulting table. If the resulting table does not exist, the schema is determined from the source table. Data types for the resulting table are inferred for the target database, but the data types can be edited.
|
Fetch Size
|
The number of rows at a time to fetch from the source table. Depending on the features of the source database JDBC driver, changes to the fetch size can improve performance.
Default value:
20000.
|
Batch Size
|
The number of rows to insert into the resulting table at one time.
Default value:
5000.
Note: Larger batches can improve speed, but they use more memory.
|