X hits on this document

416 views

0 shares

1 downloads

0 comments

39 / 131

Netezza

Knowledge Modules

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

Type

Knowledge Module

Description

Check

CKM Netezza

Checks data integrity against constraints defined on a Netezza 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 Netezza database.

This CKM is optimized for Netezza.

Integrate

IKM Netezza Control Append

Integrates data in a Netezza target table in replace/append mode. When flow data needs to be checked using a CKM, this IKM creates a temporary staging table before invoking the CKM.

Consider using this IKM if you plan to load your Netezza target table in replace mode, with or without data integrity check.

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

Integrate

IKM Netezza Incremental Update

Integrates data in a Netezza 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 Netezza 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 Netezza To File (EXTERNAL TABLE)

Integrates data in a target file from a Netezza staging area in replace mode. This IKM requires the staging area to be on Netezza It uses the native EXTERNAL TABLE feature of Netezza.

Consider using this IKM if you plan to transform and export data to a target file from your Netezza server.

To use this IKM, the staging area must be different from the

Knowledge Modules Reference Guide

39/131

Document info
Document views416
Page views419
Page last viewedSat Dec 10 00:38:59 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments