PowerExchange Express CDC for Oracle handles all character columns as variable length columns, whereas PowerExchange Oracle CDC with LogMiner handles character columns as fixed length or variable length columns. This behavioral difference affects PowerExchange column-level processing and the view of the CDC extraction map that is imported into PowerCenter. As a result, all systems that are involved in Oracle change capture processing must be aware of the Oracle CDC type that is in use.
On the PowerExchange system where the ORAD or ORCL CAPI_CONNECTION statements are defined, the CAPI_CONNECTION type implicitly defines the CDC type, and the ORACLE_CAPTURE_TYPE statement is optional. However, if other systems are involved in CDC processing, for example, because you run a separate PowerExchange Listener or use offload processing, you must define the ORACLE_CAPTURE_TYPE statement in the dbmover.cfg file on each system to explicitly define the CDC type.