Implicit conversion from source type, Possible range limit

[rameshybr]

Hi,

I am getting "Implicit conversion from source type "decimal[9,0]" to result type "decimal[7,0]": Possible range limitation." warning while running the job.

Actually the source table had decimal(13,9) and the target has decimal(9,2).
I just want to know wheter there is any transformer to propogate the value from 13,2 to 9,2.

There will be a change to get zero to append to the data if we transfome it from 13,2 to 9,2.

Please suggest if there is any way to do this.

Rd,
Ramesh.

[gowrishankar_h]

You can change the datatype length by using modify stage or transformer stage then this warning wont occur...

[chulett]

So is your source decimal(13,9) or decimal(13,2)?

While you can 'convert' one to the other (13,2 to 9,2), you're going to get that 'limitation' warning when going from a larger field to a smaller one since technically one may not fit into the other. If you are certain the values in the source will always fit the target, then you could simply demote the warning.

Otherwise, how do you plan to handle the truncation?

[rameshybr]

Hi Chulett,

sorry for the typo erro its decimal(13,2) from source and in hte target it is decimal(9,2)..

i was thinking to put a modify stage in the job,but just want to if anyother way to do it in the trnsformer level.


Rd,
Ramesh

[chulett]

Already wrote up something on that subject.