Parallel job implicit conversion error

wfkurtz1 · Post by **wfkurtz1** » Thu Mar 10, 2011 4:45 pm

Here is the error I am receiving from a Column Generator stage in a parallel job. Oracle 10g used for both source and target stages.

SAME_DAY: When checking operator: When binding output interface field "AMOUNT" to field "AMOUNT": Implicit conversion from source type "decimal[38,10]" to result type "decimal[17,2]": Possible range/precision limitation.

Thanks in advance for your help

chulett · Post by **chulett** » Thu Mar 10, 2011 6:00 pm

What part do you need help with? Did you do an exact search for "Possible range/precision limitation" to understand the warning?

wfkurtz1 · Post by **wfkurtz1** » Fri Mar 11, 2011 8:15 pm

Thanks we get rid of the warning by using a double datatype for the Datastage column (SAME_DAY) concerned.

Thanks.