My Oracle Support Banner

OGGBD - Can we have the before image values populated for the columns for which after image is not available in trail file. (Doc ID 2743638.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

Oracle GoldenGate Big Data and Application Adapters - Version 19.1.0.0.0 and later
Information in this document applies to any platform.

Goal

Was trying to use any specified column value as a Kafka Topic Key which is not the primary key
But we get null value when using

gg.handler.kafkahandler.topicMappingTemplate=<mapping template name>
gg.handler.kafkahandler.keyMappingTemplate=${columnValue[<schema>.<TABLE>=<column name>]}

Though we have all column logging enabled on source( oracle) as we are using 'updaterecordformat compact' in extract we are only having the primary key column and the updated column value available.

Can we have the before image populated for the columns for which after image is not available in trail file ?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.