DSXchange

Hi Team,
I am using below conversion in one of the derivation in Transformation stage:
DateToDecimal(Column_name,"%yyyy%mm%dd")

Which is throwing below warning:
Conversion error calling conversion routine decimal_from_date data may have been lost.

Please help to avoid above warning

What is your input and output datatypes in transformer.

What is your "Column_name" data type and your target decimal column definition (datatype and width)?

Your decimal precision must be at least 8. Its scale should be 0.