Replace NULL With Spaces Using Oracle GoldenGate Big Data Adapter
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms