X hits on this document

322 views

0 shares

1 downloads

0 comments

124 / 131

Sybase IQ

Knowledge Modules

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

Type

Knowledge Module

Description

Check

CKM Sybase IQ

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

This CKM is optimized for Sybase IQ.

Integrate

IKM Sybase IQ Incremental Update

Integrates data in a Sybase IQ 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 Sybase IQ 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 Sybase IQ Slowly Changing Dimension

Integrates data in a Sybase IQ 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 Sybase IQ 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.

Load

LKM File to Sybase IQ (LOAD TABLE)

Loads data from a File to a Sybase IQ staging area database using the LOAD TABLE SQL command.

Because this method uses the native LOAD TABLE

Knowledge Modules Reference Guide

124/131

Document info
Document views322
Page views325
Page last viewedSat Dec 03 14:55:47 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments