I am getting an error during Informatica load into teradata column (TIMESTAMP WITH TIME ZONE) ..
Input data in the Informatica is like '2011-09-09 12:12:12 2.333333 EUROPE/LONDON'
when loading this though teradata SQL assistant , this is working with out any issues..
however when using same syntax in Informatica mapping in target Override as
Update_dt =cast(:Dt as TIMESTAMP(3) WITH TIME ZONE FORMAT 'yyyy-mm-dd hh:mi:ss BZ')
this is giving error as INVALID DATE/TIME STAMP..
Not sure whether Informatica supports TIMESTAMP WITH TIME ZONE.....?
Any Suggestions or if some one wants to add some thing here..?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.