My Oracle Support Banner

Golden Gate For Big Data Numeric Overflow to Big Query (Doc ID 2640780.1)

Last updated on MAY 21, 2020

Applies to:

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


Ingesting data into Big Query. The source data is a numeric column. The data mostly is with scale of more than 10.
Invalid NUMERIC value: 0.00999999977648258 reason: invalid
Big Query only allows to have scale of 9 at the most. Is there a parameter as a generic rule where we can round the scale?

The NUMERIC value coming out of the SOURCE data is not acceptable within BigQuery. or should we change the datatype of the BigQuery table?


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.