Mapping Of Large Number Fields As Doubles Loses Precision Using AVRO Formatter
(Doc ID 2434200.1)
Last updated on AUGUST 10, 2018
Applies to:Oracle GoldenGate - Version 22.214.171.124.3 and later
Information in this document applies to any platform.
When using Oracle Golden Gate for Big Data version 126.96.36.199.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!