Page 1 of 1
my source is float target is decimal
Posted: Fri Nov 05, 2004 1:10 pm
by ranga1970
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????
Posted: Mon Nov 08, 2004 4:14 am
by roy
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,