All Forums Third Party Software
21 Apr 2013
Informatica supports teradata TIME STAMP WITH TIME ZONE or not??

Hi Experts,
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..?

You must sign in to leave a comment.