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...
Transformer warning
Moderators: chulett, rschirm, roy
Re: Transformer warning
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)DINAKAR wrote: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
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 17
- Joined: Tue May 29, 2007 8:58 am
- Location: Omaha, Nebraska