Conversion Error

aschindler · Post by **aschindler** » Tue Oct 22, 2013 2:38 am

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

prasson_ibm · Post by **prasson_ibm** » Tue Oct 22, 2013 4:09 am

What is your input and output datatypes in transformer.

ArndW · Post by **ArndW** » Tue Oct 22, 2013 4:12 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Oct 22, 2013 1:14 pm

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