floating point decimal is not fully supported; adjusting the

sudhakar_viswa · Post by **sudhakar_viswa** » Tue Aug 01, 2006 7:30 am

Hi,

I am getting the following warning.

floating point decimal is not fully supported; adjusting the scale.

My source is Oracle and target also Oracle.

Input column is containing the number but that column datatype is varchar.I am populating this column into target.Target column datatype is NUMBER.

I gone through searching,but i could not findout solution.Can anybody suggest me

Thanks & Regards,
-- sudhakar

us1aslam1us · Post by **us1aslam1us** » Tue Aug 01, 2006 10:34 am

Have you tried the "stringtodecimal" transform?

Sam

thompsonp · Post by **thompsonp** » Wed Aug 02, 2006 3:29 am

How have you defined the NUMBER column in the database?
Try constraining it e.g. NUMBER(38,0)

balajisr · Post by **balajisr** » Wed Aug 02, 2006 3:41 am

Check the precision and scale in the source and apply the same to the target.

for e.g The above error may occur if source is number(38,4) and target is number(38,0).