1. Oracle GoldenGate for Distributed Applications and Analytics
  2. Administer
  3. Oracle GoldenGate Java Delivery
  4. Java Delivery Properties
  5. Java Application Properties
  6. Properties for CSV and Fixed Format Output
  7. gg.handler.name.format.missingColumnChar

9.4.3.3.3.4 gg.handler.name.format.missingColumnChar

Specifies a special column prefix for a column value that was not captured from the source database transaction log. The column value is not in trail and it is unknown if it has a value or is NULL

The character used to represent the missing state of the column value can be customized. For example:

gg.handler.handler1.format.missingColumnChar=M

By default, the missing column value is set to an empty string and does not show.

Parent topic: Properties for CSV and Fixed Format Output