Connect CDC supports the copying and replication of long datatype columns, that is, columns that contain large objects. The support is limited to IMAGE, TEXT, and NTEXT datatypes in MS SQL Server, IMAGE and TEXT in Sybase (Copy only), and to LONG, LONG RAW, CLOB and BLOB datatypes in Oracle.
Distributing long datatype columns requires no additional Connect CDC installation, setup, or modeling considerations, except that you cannot use such columns for data transformation, Distribution Keys, or conditional selection. In addition, Connect CDC conflict detection does not report exact long column values if a row containing a long column has a conflict.
See also System Reference for specific information on long column data.