X hits on this document

332 views

0 shares

1 downloads

0 comments

22 / 131

Informix

Knowledge Modules

Refer to section “Generic SQL” for additional Knowledge Modules that work with this database.

Type

Knowledge Module

Description

Integrate

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.

Load

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.

Reverse- Engineer

RKM Informix

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

22/131

Document info
Document views332
Page views335
Page last viewedSun Dec 04 04:22:29 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments