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.

Symptoms

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).

Cause

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