X hits on this document

546 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 views546
Page views549
Page last viewedMon Jan 23 13:26:20 UTC 2017
Pages131
Paragraphs3942
Words42855

Comments