PowerExchange Express CDC for Oracle Configuration File
PowerExchange Express CDC for Oracle Configuration File
PowerExchange 10.0 introduces a new parameter in the OPTIONS statement of the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
OPTIONS statement
The OPTIONS statement can now include the following optional parameter:
TRUNCINVALIDCHARS
Indicates whether to detect and remove invalid multibyte characters that appear at the end of a character field in an Oracle source table. The characters are invalid because they have been truncated. If you allow these invalid characters to be passed to a PowerCenter workflow that has an Oracle target, PowerCenter might corrupt subsequent columns in the target table when running in Unicode mode.
Options are:
Y
. Remove invalid multibyte characters from the source data. The invalid characters are not passed to PowerCenter or applied to the target database.
N
. Capture the invalid multibyte characters and pass them to PowerCenter. When the PowerCenter workflow tries to write the invalid characters to the target, Oracle issues an ORA-02290 error that reports a check constraint violation on the target database. Also, PowerCenter might corrupt data in the subsequent columns in the target table.
Default is N. If you receive the ORA-02290 error in this situation, set this parameter to Y.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows