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..?
 
Cheers!
Nishant 
 

You must sign in to leave a comment.