Unexpected output from Double Precision
Posted: Tue Dec 03, 2013 9:53 am
Source is a sequential file, reading COL1 and COL2 as Double Precision. Target is an Oracle table. Output is not what is expected.
SOURCE:
COL1,COL2
-10240547.950000,219892.738536
current output:
COL1,COL2
-10240547.949999999,219892.73853599999
expected output:
COL1,COL2
-10240547.950000,219892.738536
In DataStage both COL1 AND COL2 are defined as Double.
In target Oracle table both columns are defined as Float(126). I do not have any control over target format table data type or length.
[Note: Topic / Title edited for clarity - Andy]
SOURCE:
COL1,COL2
-10240547.950000,219892.738536
current output:
COL1,COL2
-10240547.949999999,219892.73853599999
expected output:
COL1,COL2
-10240547.950000,219892.738536
In DataStage both COL1 AND COL2 are defined as Double.
In target Oracle table both columns are defined as Float(126). I do not have any control over target format table data type or length.
[Note: Topic / Title edited for clarity - Andy]