Refer to section “Generic SQL” for additional Knowledge Modules that work with this database.
CKM Sybase IQ
Checks data integrity against constraints defined on a Sybase IQ table. Rejects invalid records in the error table created dynamically. Can be used for static controls as well as flow controls.
Consider using this KM if you plan to check data integrity on a Sybase IQ database.
This CKM is optimized for Sybase IQ.
IKM Sybase IQ Incremental Update
Integrates data in a Sybase IQ target table in incremental update mode. This IKM creates a temporary staging table to stage the data flow. It then compares its content to the target table to guess which records should be inserted and which others should be updated. It also allows performing data integrity check by invoking the CKM.
Inserts and updates are done in bulk set-based processing to maximize performance. Therefore, this IKM is optimized for large volumes of data.
Consider using this IKM if you plan to load your Sybase IQ target table to insert missing records and to update existing ones.
To use this IKM, the staging area must be on the same data server as the target.
IKM Sybase IQ Slowly Changing Dimension
Integrates data in a Sybase IQ target table used as a Type II Slowly Changing Dimension in your Data Warehouse. This IKM relies on the Slowly Changing Dimension metadata set on the target datastore to figure out which records should be inserted as new versions or updated as existing versions.
Because inserts and updates are done in bulk set-based processing, this IKM is optimized for large volumes of data.
Consider using this IKM if you plan to load your Sybase IQ target table as a Type II Slowly Changing Dimension.
To use this IKM, the staging area must be on the same data server as the target and the appropriate Slowly Changing Dimension metadata needs to be set on the target datastore.
LKM File to Sybase IQ (LOAD TABLE)
Loads data from a File to a Sybase IQ staging area database using the LOAD TABLE SQL command.
Because this method uses the native LOAD TABLE
Knowledge Modules Reference Guide