Enabling Table Truncation

The Bulk Load Handler page features a Truncate Table(s) option that you can set so that the system truncates the database table(s) prior to handler processing. The option is located under the Non-Destructive Load option on the Bulk Load Handler page.

By default, the Truncate Table(s) option is enabled and the PeopleSoft system performs table truncation. However, if you do not wish to perform table truncation you can deselect the option to disable table truncation.

To enable/disable table truncation:

1. Access the Bulk Load Handler page (PeopleTools, and then Integration Broker, and then Integration Setup, and then Service Operation Definitions and click the Handlers tab. Click the Details link for the bulk load handler).

2. On the Truncate Table(s) check box perform one of the following options:

   • To enable table truncation, select the check box.

   • To disable table truncation, deselect the check box.

3. Click the OK button.