Replicat Losing Precision With replication From Sybase Float To Oracle Number
(Doc ID 1341215.1)
Last updated on APRIL 03, 2019
Applies to:Oracle GoldenGate - Version 10.4.0.19 and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
The replicat is only updating/inserting 16 significant digits(before and after the decimal point) when replicating sybase float to oracle number(without Precision) when the source float numbers have 17 (or more) significant digits
Eg Sybase Float 566776357.6548000574111938
After replication to Oracle Number 566776357.6548001
Sybase Float 900000.0670000000391155
After replication to Oracle Number 900000.067
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