5 Replies Latest reply on Aug 4, 2020 2:33 AM by Akshay Shaha

    How to use Relational Connection, to login into Teradata in ANSI mode?

    Akshay Shaha New Member

      Hi all,

       

      We need to login to Teradata database, in ANSI mode, using Relational Connection, for case-sensitive lookup comparison.

      Currently Informatica Relational Connection, is logging with default Tetadata BTET mode.

       

      Also we are not allowed to modify odbc.ini file, so configuration change has to be limited to Relational Connection.

       

      We tried setting below property in Relational Connection, but it is throwing syntax error.

       

      "Connection Environment SQL = SET SESSION TRANSACTION ANSI;"

       

       

      Informatica Version - 10.2 HF

      Teradata Version - 16.2