Transformer warning

[DINAKAR]

Hello all,


I am getting following warning in my job,

transform,3: Conversion error calling conversion routine decimal_from_string data may have been lost [transform/tfmop_functions.C:147]


My job flow is like

ip dataset->transfrom->op dataset


I have nearly 1000 derivations in transformer, not sure for which field warning is coming is there any way to figure it out.... In this warning no colun name mentioned, appreciate your response...

[Obuli]

Hello all,


I am getting following warning in my job,

transform,3: Conversion error calling conversion routine decimal_from_string data may have been lost [transform/tfmop_functions.C:147]


My job flow is like

ip dataset->transfrom->op dataset


I have nearly 1000 derivations in transformer, not sure for which field warning is coming is there any way to figure it out.... In this warning no colun name mentioned, appreciate your response...

You are trying to convert the datatype from string to decimal without using conversion function. Try to figure out which column you are converting from string to decimal and use the conersion function StringToDecimal(columnname)

Obuli

[arnabdey]

use the StringToDecimal(...) function

[Sreenivasulu]

Sometimes if you are doing the right way they give warnings.

Regards
Sreeni

[larzmcelroy]

perhaps [transform/tfmop_functions.C:147] is pointing to the actual column within the transform.