Source is Oracle Table and target is also oracle table.
Col1 is Number datatype in source table and Col1 is Float(126) datatype in Target table.One to one mapping between source and target.In Datastage job i am reading col1 as Decimal 38,10 and propagating this field till target.In some cases I am not getting correct output.
SOURCE:
COL1
-10240547.950000
current output:
COL1
-10240547.949999999
expected output:
COL1
-10240547.950000
TO be short what ever it is there in source i need in target with out rounding.
Data Issue with Datatype
Moderators: chulett, rschirm, roy
Not really any different from your other post discussing this data type I'm afraid.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No computer can store float data type accurately 100% of the time. There are IEEE papers out there explaining why. You could try changing the data type to DECIMAL(38,2) or using explicit rounding functions.
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.