Normal Error Handling

Principles for normal error handling are as follows:

• If you do not set a bulk insert size, the Data Merger activity inserts error data into either the exception table or opaque exception table.
• If you set both a bulk insert size and a batch commit size, the Data Merger activity inserts data in the following ways:
  • If all the data in a bulk is processed successfully, the Data Merger activity inserts all the data in the bulk in the destination table.
  • If all the data in a bulk is not processed successfully, the Data Merger activity inserts all the data, including the error data, in the bulk in either the exception table or opaque exception table.