my source is float target is decimal
Moderators: chulett, rschirm, roy
my source is float target is decimal
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????
RRCHINTALA
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,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org