Datatype considerations - 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

If you select Copy column for Method, the Source Data list contains only the sending table columns whose datatypes are compatible with the Target Column value. If the datatype mappings are compatible but possibly problematic or may require data truncation or rounding, the Connect CDC Director warns you (when you click OK or at model validation time) but lets you continue.   

To determine whether datatypes are compatible, the Connect CDC Director uses a matrix of generic categories instead of comparing every pair of DBMS SQL datatypes. For more information about Connect CDC datatype categories and conversion rules, see the System Reference.