X hits on this document

380 views

0 shares

1 downloads

0 comments

34 / 131

Microsoft Access

Knowledge Modules

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

Type

Knowledge Module

Description

Integrate

IKM Access Incremental Update

Integrates data in a Microsoft Access 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.

Consider using this KM if you plan to load your Micrsoft Access 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.

Knowledge Modules Reference Guide

34/131

Document info
Document views380
Page views383
Page last viewedWed Dec 07 09:04:06 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments