Specifying DBMS loader options

Use the Load Options tab in the Load Service Editor to specify options for each DBMS loader.

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:

  1. Expand a folder in the Directory Explorer that contains the load service, expand the Load Services node, and double-click the load service to edit. The Load Service Editor opens.
  2. Select the Load Options tab.
  3. Select the target data store alias.
  4. Edit the service processing options.
  5. Save the load service.


Feedback