You can specify the following processing options:
- Select the type of processing to be performed. Specify parameters
to lock tables, set a commit frequency and set a discard row limit.
- Delete rows from all or specified tables. Delete is useful for
restoring data during testing. If a row cannot be deleted for any
reason, all deleted rows up to the last commit are restored, and insert
processing stops.
- Disable database triggers.
- Disable database constraints.
Row processing includes the following options:
- Insert
- Inserts new rows into the tables.
- If the primary key of a row in the source data does
not match the primary key of a row in the destination table, the
row is inserted.
- If the primary key of a row in the source data matches the
primary key of a row in the destination table, the row is bypassed
and marked as discarded.
- Mixed
- Updates, inserts, or updates/inserts according to
your selection for each table on the Specify by Table window.
To use the Specify by Table window, click Specify
by Table and select a process option for each table.
- If you select Mixed and do
not specify selections on the Specify by Table window,
or you set all tables to the same selection, the process option changes
to indicate the process used for all tables.
Note: You cannot select Mixed if All
rows will be deleted is selected in the Row
delete options area.
- Update
- Updates rows in the tables. Tables must have a primary
key.
- If the primary key of a row in the source data matches the
primary key of a row in the destination table, the row is updated.
- If the primary key of a row in the source data does
not match the primary key of a row in the destination table, the
row is reported as failed.
Note: You cannot select Update if All
rows will be deleted is selected in the Row
delete options area.
- Update/Insert
- Updates and inserts rows in tables. Tables must
have a primary key.
- If the primary key of a row in the source data does
not match the primary key of a row in the destination table, the
row is inserted.
- If the primary key of a row in the source data matches the
primary key of a row in the destination table, the row is updated.
Note: You cannot select Update/Insert if All
rows will be deleted is selected in the Row
delete options area.
To specify insert processing options: