X hits on this document

339 views

0 shares

1 downloads

0 comments

35 / 131

Microsoft SQL Server

Knowledge Modules

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

Type

Knowledge Module

Description

Integrate

IKM MSSQL Incremental Update

Integrates data in a Microsoft SQL Server 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 processing to maximize performance. Therefore, this IKM is optimized for large volumes of data.

Consider using this IKM if you plan to load your Microsoft SQL Server 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 MSSQL Slowly Changing Dimension

Integrates data in a Microsoft SQL Server 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 Microsoft SQL Server 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 MSSQL Consistent

Creates the journalizing infrastructure for consistent journalizing on Microsoft SQL Server tables using triggers.

Enables consistent Changed Data Capture on Microsoft SQL Server.

Journalize JKM MSSQL Simple

Creates the journalizing infrastructure for simple journalizing on Microsoft SQL Server tables using triggers.

Enables simple Changed Data Capture on Microsoft SQL Server.

Knowledge Modules Reference Guide

35/131

Document info
Document views339
Page views342
Page last viewedSun Dec 04 13:25:28 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments