my source is float target is decimal

ranga1970 · Post by **ranga1970** » Fri Nov 05, 2004 1:10 pm

my source is float target is decimal if i map directly some of the data is being lost and my job is throwing warnings, i am using format function but it not of much help, could some one hel or Suggest????

roy · Post by **roy** » Mon Nov 08, 2004 4:14 am

Hi,
can you give some examples?

what percision do you have in source value?
what percision in target decimal?

usually a rounding of percision will ocurr if you got a 0.123456 and put it to decimal(x,4)

if you use matematic calculations befor putting the result in target you might want to try the string mathematic functions of SADD and the likes.

IHTH,