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.