Replace NULL With Spaces Using Oracle GoldenGate Big Data Adapter
(Doc ID 2305654.1)
Last updated on SEPTEMBER 15, 2017
Applies to:Oracle GoldenGate Application Adapters - Version 12.3 and later
Information in this document applies to any platform.
Trying to replace NULL with spaces using
gg.handler.name.format.nullValueRepresentation=CDATA[" "] or some form of that in properties file for HDFS.
Tried several variations and still see where GG inserts "NULL" value. Example: 2017-08-30 23:59:59^\3459568021^\US^\NULL^\NULL^\0^\0^\0^\0^\0^\1. We want NULL to be replaced with a space or string. Using BigData Adapter for HDFS (Hadoop).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!