#DateForumTypeThreadPost
323 Apr 2009 @ 12:07 PDTUDATopicSending System Date to Char(26) with Nano SecondHi,I have a nice problem.I have to send the system date to a char(26) field with Nano second using Informatica V8.My database is Teradata.I am using this logic -- to_char(sysdate,'YYYY-MM-DD-HH24.M...
220 Apr 2009 @ 04:08 PDTUDATopicUpdate Strategy with TeradataHi,In Informatica, if we use update strategy we need Primary key in Target table.But in teradata we can't set primary key I think.Update strategy fails if target table does not have any Primary Key...
116 Apr 2009 @ 03:00 PDTAnalyticsTopicCoverting Char to DateHi,I am new to Teradata.In oracle if we want to convert char to date, we write like this e.g. to_date('20090417','YYYYMMDD').Could you please tell me how to do that in teradata.Thanks & Regards.Roy