Hi
I am attempting to do change capture on SQL Server source into Oracle Target. The SQL Server has fields with type Real which gets imported into DataStage as type Float. When I run it through the change capture, I am getting differences even though the values are the same. Also it appears DataStage is rounding the value.
Here's an example:
SQL Server value: 134623.5
Oracle Value: 134623.5
However If I place this in a peek stage, it shows as: 134624
Any ideas?
Change Capture Real Type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You might like to search here and elsewhere to learn why computers can not precisely store real (sfloat or dfloat) numbers.
Convert to decimal before effecting any comparison - you can preserve the floating point numbers, but compare the decimal numbers.
Convert to decimal before effecting any comparison - you can preserve the floating point numbers, but compare the decimal numbers.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.