Compare the contents of the source and target tables - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2024
First publish date
2003
Last edition
2024-07-19
Last publish date
2024-07-19T23:30:25.334335

The target tables in the first distribution (Oracle_new) are populated with snapshot copies of the source table columns selected for distribution. The result at the target that used the reference mapping is the same as the result at the target it referenced.

The target tables in the second distribution (OraMssMerge) have a mixture of source and target column values in the records whose keys matched copied source records. In addition, they have some entirely new records from the source (new, unmatched keys) and some of the same records (keys not matched in the source copy) they had before.