Refer to section “Generic SQL” for additional Knowledge Modules that work with this database.
IKM Informix Incremental Update
Integrates data in an IBM Informix 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 IBM Informix 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.
Journalize JKM Informix Consistent
Creates the journalizing infrastructure for consistent journalizing on IBM Informix tables using triggers.
Enables consistent Changed Data Capture on IBM Informix.
Journalize JKM Informix Simple
Creates the journalizing infrastructure for simple journalizing on IBM Informix tables using triggers.
Enables simple Changed Data Capture on IBM Informix.
LKM Informix to Informix (SAME SERVER)
Loads data from a source Informix database to a target Informix staging area located inside the same server.
This LKM creates a view in the source database and a synonym in the staging area database. This method if often more efficient than the standard “LKM SQL to SQL” when dealing with large volumes of data.
Consider using this LKM if your source tables are located on an IBM Informix database and your staging area is on an IBM Informix database located in the same Informix server.
Retrieves IBM Informix specific metadata for tables, views, columns, primary keys and non unique indexes. This RKM accesses the underlying Informix catalog tables to retrieve metadata.
Consider using this RKM if you plan to extract additional metadata from your Informix catalog when it is not provided by the default JDBC reverse-engineering process.
Knowledge Modules Reference Guide