My Oracle Support Banner

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

Last updated on APRIL 09, 2020

Applies to:

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


When using Oracle Golden Gate for Big Data version 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. 




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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