Tuesday, March 29, 2011

Informatica 8.6.1: How To Avoid Erros Due to Reserved Words



In order to avoid SQL error at run-time due to reserved words at columns names you can do the following:


    1.  Create a reserved words file, reswords.txt, in the <PowerCenter_Home>\server\bin directory.
    2.  Specify the reserved words in the reswords.txt.



           Following is a sample resword.txt file:


           [SQL Server]
           RETURN
           TRANSACTION

            In the reswords.txt file, the following connection headers can be provided: 
            
                    [Teradata]
                    [Oracle]
                    [DB2]
                    [Sybase]
                    [Informix]
                    [SQL Server]
                    [ODBC]
                    [NEOVIEW]
                    [Netezza]


    3.  In Informatica Administrator, select the Data Integration Service and ddit the custom properties. 


    4. Add the following custom property:



    5.  Restart Integration Service. 


    6.  (OPTIONAL) Set the following value under Custom Properties in the Session Config Object 
          Properties tab:


                    ?Attribute: ReservedWordsFile
                    ?Value: C:\informatica\Powercenter8.6.1\server\bin\resword.txt






No comments:

Post a Comment