X hits on this document

392 views

0 shares

1 downloads

0 comments

16 / 131

IBM DB2 UDB

Knowledge Modules

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

Type

Knowledge Module

Description

Integrate

IKM DB2 UDB Incremental Update

Integrates data in an IBM DB2 UDB 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 DB2 UDB 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.

Integrate

IKM DB2 UDB Slowly Changing Dimension

Integrates data in an IBM DB2 UDB 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 IBM DB2 UDB 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.

Journalize JKM DB2 UDB Consistent

Creates the journalizing infrastructure for consistent journalizing on IBM DB2 UDB tables using triggers.

Enables consistent Changed Data Capture on IBM DB2 UDB.

Journalize JKM DB2 UDB Simple

Creates the journalizing infrastructure for simple journalizing on IBM DB2 UDB tables using triggers.

Enables simple Changed Data Capture on IBM DB2 UDB.

Knowledge Modules Reference Guide

16/131

Document info
Document views392
Page views395
Page last viewedWed Dec 07 22:25:51 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments