My Oracle Support Banner

Mapping Of Large Number Fields As Doubles Loses Precision Using AVRO Formatter (Doc ID 2434200.1)

Last updated on AUGUST 18, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Symptoms

When using Oracle Golden Gate for Big Data version 12.3.0.1.0 to replicate changes from an oracle DB into kafka using the kafka handler in AVRO Format. 

When defined a large number on the source DB, e.g. NUMBER(19) this value is being mapped to a double. According to IEEE 754 double, double has a precision of 15-17 digits, which means that OGG does not guarantee the full precision of a value that has more than 15-17 digits before the comma. 

Since those long values may be used as primary keys in your source data, the full precision of the data might be needed. 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.