DSXchange

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.

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

or is it a modelling issue where the target was supposed to be varchar ?