Hi,

I am loading data using Informatica and source is oracle and target is teradata. Now i am getting loss of record because of improper date formate.

Here is the expression i wrote in informatica.

IIF((CALENDAR_DATE2=to_date('01/01/2004','mm/dd/yyyy')),IIF((CALENDAR_DATE1=
to_date('01/01/2004','mm/dd/yyyy')),to_date('01/01/2004','mm/dd/yyyy'),CALENDAR_DATE1),CALENDAR_DATE2 )

now to_date is not work for teradata, this calendar_date is under teradata date formate with '2004-01-01' 'yyyy-mm-dd' . can anybody know how to write the above expression in teradata date format .

Thanks in adavance