To Avoid Warning While Execution

[Sachin K.C.]

Hi, In my job i have used StringToDecimal function in many places, while running job i am getting the below warning in DS Director , but i could not able to trace the warning raises through which transfemation stage step.

xfrmLoadData,1: Conversion error calling conversion routine
decimal_from_string data may have been lost

Can anyone suggest me the method for avoiding the above warning / debug method?

[kris007]

Hi Sachin, Welcome aboard.

The method to avoid this warning is to solve it. From the error message it appears that you are not converting your string to Decimal correctly. It is also complaining about it in the stage xfrmLoadData. Check if you are doing the conversion correctly in that transformer. For more help, post the derivation you are using in the transformer stage.

[Kirtikumar]

This error is shown when the target decimal datatype has length less than string. E.g. if your string is 12345 having 5 chars and you are trying to store it in the decimal field with less than 5 length.

Whats the source and target col datatypes?