Source column Datatype is Varchar(16) and Data is coming like
D3476654765
766546799989G
87978675436L
And Target Column Data type is Decimal(20,0)
I am doing Type conversion StringToDecimal(Src.Column)
This function is not handling this column and getting warning as "Conversion error calling conversion routine Decimal_from_string data may have been lost"
In the Target i am getting Default Value like
0
0
0
Thanks in advance.
Transformer Error(Type Conversion)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Mon Aug 08, 2011 3:20 am
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
have a logical thought, how would datastage convert alphanumeric values into a decimal ?
your data is not fit to be converted into a decimal, you need to have additional logic to strip off alphabets and then convert the remaining but it would rather be better to fix at the source itself by identifying where things are going wrong rather than ETL tweeking the data
your data is not fit to be converted into a decimal, you need to have additional logic to strip off alphabets and then convert the remaining but it would rather be better to fix at the source itself by identifying where things are going wrong rather than ETL tweeking the data
- Zulfi
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore