You can specify the following options:
- A processing mode.
- Options that are specific to each target data store alias.
Depending on the DBMS of the selected target file, the
following processing modes are available:
- Insert
- Inserts rows from the source file into empty target
tables. If target tables contain data, the loader returns an error.
- Replace
- Clears and replaces all of the existing rows in
the target tables with the rows from the source file. (Replace might
be significantly more resource-intensive than Truncate since
no logging is performed.)
- Append
- Inserts the rows from the source file into the target
tables. If the primary key values match, duplicate rows are discarded
or inserted into the exception table (if specified).
- Truncate
- Truncate is the same as Replace but
the database does not log the rows being deleted, and Truncate requires
that RI constraints are disabled.
To specify DBMS loader options: