Error transforming the date in informatica session
JV123Oct 6 2011 — edited Oct 8 2011Hi,
Source tables has a string column called Attribute11 and actual data is date in the format ex: 21-Mar-2005. I'm trying to transform attribute column as air_to_date (date data type) in target using to_date and to_char conversion functions in expression transformation but some how Im getting below
Port [AIR_TO_DATE]: Default value is: ERROR(<<Expression Error>> [ERROR]: transformation error
... nl:ERROR(u:'transformation error')).
in expression attribute11 --input port
created attrinute11_var(date dat type)=TO_DATE(ATTRIBUTE11,'DD-MON-YYYY')
created air_to_date=TO_DATE(TO_CHAR(ATTRIBUTE11_VAR,'DD-MON-YYYY'),'MM/DD/YYYY')
How sould I fix the transformation error?
Thanks
Jay.