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
Conversion Error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore
Conversion Error
Cheers,
Schindler
Schindler
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
What is your input and output datatypes in transformer.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
What is your "Column_name" data type and your target decimal column definition (datatype and width)?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: