Before you run external loaders, complete the following tasks:
You disable constraints built into the tables receiving the data before performing the load. For information about disabling constraints, see the database documentation.
Turn off or disable database logging.
To preserve high performance, you can increase commit intervals and turn off database logging. However, to perform database recovery on failed sessions, you must have database logging turned on.
Configure code pages.
IBM DB2, Oracle, Sybase IQ, and Teradata database servers must use the same code page as the target flat file code page. The Integration Service creates the control files and target flat files using the target flat file code page. If you use a code page other than 7-bit ASCII for the target flat file, run the Integration Service in Unicode data movement mode.
Configure the external loader connection as a resource.
If the Integration Service is configured to run on a grid, configure the external loader connection as a resource on the node where the external loader is available.