DSXchange

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

Have you tried the "stringtodecimal" transform?

Sam

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

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).