Duplicate keys - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

Connect CDC detects duplicate keys and accepts only one record for a certain key, rejecting all others. Select Skip Records as the Error Mode. In this mode, only one record is allowed per key and duplicates are rejected. All other rows in the batch are processed. This has been implemented for the Oracle loader, MS SQL Server loader, and Teradata loader.

When using the MS SQL Server loader, Connect CDC detects duplicate keys by using an index that enforces uniqueness. Thus, it ignores a row with a duplicate key but loads all other rows in the same batch or transaction. The index must be defined with the IGNORE_DUP_KEY option.