Distribute and transform columns - 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

How do I distribute a subset of a table’s columns to a target, some of which need their values transformed? 

One of the principal tasks of Connect CDC modeling is to identify the pairings of source data columns with the target columns to which their data is replicated or copied. These column associations, or mappings, are defined automatically by default in Connect CDC Director when source and target table and column names are identical or nearly so. The Connect CDC Getting Started Guide features an example of this default mapping.

In the Connect CDC Getting Started Guide  examples, all source column values were enabled for copying to corresponding target columns, and all source columns were enabled for capture and replication. No columns were excluded, and no columns required additional adjustment or transformation of their data before being applied at the target.

If you are distributing a subset of a table’s columns or need to transform some of the distributed data values, however, you must manually specify these requirements in Connect CDC Director.