My Sourcedata is Varchar and Target data is Decimal. I am using stringtodecimal(col1) in the Transformer.I get the following warnings."Conversion error calling conversion routine decimal_from_string data may have been lost" .
Can anyone please help me how to get rid of this warning
You cannot get rid of this warning altogether, but you can set up a job level or project level handler for the message and either deprecate it (turn it into an informational message) or remove it from the logs altogether.