X hits on this document

413 views

0 shares

1 downloads

0 comments

19 / 131

IBM DB2/400

Knowledge Modules

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

Type

Knowledge Module

Description

Integrate

IKM DB2 400 Incremental Update

Integrates data in an IBM DB2/400 target table in incremental update mode. This KM 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 SQL 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/400 target table to insert missing records and to update existing ones using SQL.

To use this IKM, the staging area must be on the same data server as the target.

Integrate

IKM DB2 400 Incremental Update (CPYF)

Integrates data in an IBM DB2/400 target table in incremental update mode. This IKM is similar to the “IKM DB2 400 Incremental Update” except that it uses the CPYF native OS/400 command to write to the target table, instead of set-based SQL operations. It can be more efficient in some particular cases.

Consider using this IKM if you plan to load your IBM DB2/400 target table to insert missing records and to update existing ones using native OS/400 commands rather than set-based SQL.

Integrate

IKM DB2 400 Slowly Changing Dimension

Integrates data in an IBM DB2/400 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/400 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

Knowledge Modules Reference Guide

19/131

Document info
Document views413
Page views416
Page last viewedFri Dec 09 19:25:50 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments