Refer to section “Generic SQL” for additional Knowledge Modules that work with this database.
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