Insert data in the target table - 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

Instead of replicating source table changes to a target table, journal mapping inserts a series of entries in the target table, one row for each insert, update, or delete at the source.

The transactions are sent to the journal (target table) as SQL INSERTs.

Transaction

What It Includes

Source INSERTs

  • values of all derived columns, including system variables, mapped to the Target

Source UPDATEs

  • values of all source columns marked for distribution that did change

  • values of all derived columns in which the constituent source columns did change

Source DELETEs

  • values of all source columns that participate in the Distribution Key

The following information is sent to the target.

Row Manipulation Type

Before values

Sends to target

Insert

NULL

  • All mapped columns

  • All derived columns, including system variables

Update

update column only

  • All mapped columns

  • Values of mapped functions, including system variables, that do not derive from a source column

  • All derived columns in which the source columns changed

Delete

NULL

  • All values of system variables

  • Any other mapped functions that do not derive from a source column