OGG For PostgreSQL To OGG Big Data: Unexpected Boolean Data Type Values Received (Doc ID 2843929.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

Extracts and replicates to Big Data targets from several RDBMS database types including Oracle, MySQL and PostgreSQL.
We are now seeing problems in which the values replicated for PostgreSQL Boolean types are showing up in the target Hadoop File system in "binary" form.

Also note that when an initial data load is perform using loader program, the Boolean values come across as True and False.
Furthermore I believe these Boolean values are stored in the source database as 0 and 1 (False and True) respectively.

How can we GoldenGate to land the Boolean values on the target Hadoop system as either...
1) 0 and 1
2) False and True
 

Solution

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