Specifying insert processing options

Use the Processing Options tab in the Insert Service Editor to specify insert service processing options.

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:

  1. Expand a folder in the Directory Explorer that contains the insert service, expand the Insert Services node, and double-click the insert service to edit. The Insert Service Editor opens.
  2. Select the Processing Options tab.
  3. Edit the service processing options.
  4. Save the insert service.


Feedback