command, it is more efficient than the standard “LKM File to SQL” when dealing with large volumes of data. However, the loaded file must be accessible from the Sybase IQ machine.
Consider using this LKM if your source is a large flat file and your staging area is a Sybase IQ database.
LKM SQL to Sybase IQ (LOAD TABLE)
Loads data from any Generic SQL source database to a Sybase IQ staging area database using the native LOAD TABLE SQL command.
This LKM unloads the source data in a temporary file and calls the Sybase IQ LOAD TABLE SQL command to populate the staging table. Because this method uses the native LOAD TABLE, it is often more efficient than the “LKM SQL to SQL” method when dealing with large volumes of data.
Consider using this LKM if your source data located on a generic database is large, and when your staging area is a Sybase IQ database.
Some of the Knowledge Modules for Sybase IQ use the LOAD TABLE specific command. The following restrictions apply when using such Knowledge Modules. Refer to the Sybase IQ documentation for additional information on these topics.
The file to be loaded by the LOAD TABLE command needs to be accessible from the Sybase IQ machine. It could be located on the file system of the server or reachable from a UNC (Unique Naming Convention) path or mounted from a remote file system.
UNC file paths are supported but not recommended as they may decrease performance.
For performance reasons, it is often recommended to install Oracle Data Integrator Agent on the target server machine.
Knowledge Modules Reference Guide