Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Json format in Kafka replication does not show all columns data for updates
설명
When replicating data from Oracle to Kafka in Json format, Updates does not display all column data.
원인
Updates by default on the redo log will only have the modified and the pre-image columns displayed in the update DML.
해결 방안
Enable supplemental logging for all the columns to display all column data in the redo log. SharePlex will replicate all column data to the target by setting SP_OCT_REDUCED_KEY to 1 on Source and SP_OPX_REDUCED_KEY to 0 on Target(default values).
