Sessions in Informatica can be configured to use IBM DB2, Oracle, Sybase IQ and Teradata external loaders to load target files into their respective database.
Certain rules need to be followed before you begin to run external loaders.
- Disable Constraints – You disable constraints built into the tables receiving the data before performing the load.
- Turn off or disable database logging – By increasing the commit intervals and turning off the database logging you can preserve high performance in the database; but to perform database recovery on failed sessions, you must have database logging turned on.
- Configuring the code pages – All the external database servers must use the same code page as the target flat file code page. The integration services in Informatica create the control files and target flat files using the target flat file code page.
- Configuring the external loader connection as a resource – If the integration service is configured to run on a grid then configure the external loader connection as a resource on the node where the external loader is available.
DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.