Could not load correct values using float datatype
Posted: Tue Jun 21, 2011 1:28 pm
Hi,
I am fetching values from Sybase and loading it into Oracle tables. One of the columns in the table is float datatype and when it is loaded into Oracle it rounds it off.
eg. -39238453.3 is getting loaded as -39238500
Sybase -> transformer(map cols) -> Oracle
In source as well as target I am using float for the column. It is column to column mapping and no calculations performed.
Appericiate you help on this.
Thanks
I am fetching values from Sybase and loading it into Oracle tables. One of the columns in the table is float datatype and when it is loaded into Oracle it rounds it off.
eg. -39238453.3 is getting loaded as -39238500
Sybase -> transformer(map cols) -> Oracle
In source as well as target I am using float for the column. It is column to column mapping and no calculations performed.
Appericiate you help on this.
Thanks