4 Replies Latest reply on Apr 19, 2021 12:15 AM by Saurabh Shrivastava

    Teradata Timestamp with Timezone Issue in Informatica mapping

    Saurabh Shrivastava Guru

      Hello All,

       

      I am creating a mapping where Teradata table is a source and target is a flat file(.csv).

      I am reading the entire data from the source table (17256447 records). Since the source count is huge, so I am using Teradata PT connection for source.

       

      Several of source fields are defined as TIMESTAMP WITH TIMEZONE datatype having data in the form of 2019-03-05 12:38:48.000000+00:00

       

      I am not able to load this type of data in my target flat file in the corresponding fields/columns. Blank is getting populated for such fields in Target flat file.

       

      Can someone please help me what changes etc do I need to do in my SQ, Expression transformation, Target so that this kind of data gets loaded in the target flat file.

       

      I saw one KB Article: Support which says that Informatica does not support TimeStamp with Timezone data type...

      Is there any solution for it..??