Could not load correct values using float datatype

xch2005 · Post by **xch2005** » 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

xch2005 · Post by **xch2005** » Fri Jun 24, 2011 9:41 am

Is there a way how we can fix this?