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.

Goal

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?
 

Solution

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
Goal
Solution


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