In Informatica, while querying a relational source using SQL overrides the session fails if you use words that are defined as keywords in the target database. for example words like USER, MONTH, YEAR etc are reserved keywords in many popular databases. These words are termed as reserved keywords.
In order to query tables or columns with reserved names you have two options:-
1. Enclose the table or column name in double quotes in the SQL query override.
2. Create a file named reswords.txt in your installation directory of the Integration service, (Usually it is server/bin directory) and add all the reserved words in that file. The text is not case sensitive.
You can create a section for each database you are using your integration service with e.g.:-
Integration service at run time will lookup this file and will automatically place quotes around reserved words and then issue the query to the database.
You may need to turn on SQL-92 standards for some database to use quoted identifiers. Use the connection environment SQL to issue the command. For e.g. for MS SQL server issue the following command:-
SET QUOTED_IDENTIFIER ON
Leave a comment if you need any more details.