Syntax error expected something like a name between ',' and the 'LE' keyword

Database

Syntax error expected something like a name between ',' and the 'LE' keyword

Hi, I am using Informatica 9.5.1 to load data from Oracle 11g to Teradata. I have created a mapping from Source [OLTP] to target [OLAP]. I get an error while running the workflow and it says "Syntax error expected something like a name between ',' and the 'LE keyword". Target table column has "LE" and it is a keyword in Teradata. Can you help me how we can make it work without changing the column name in Teradata? 

Source Table [TRIP] - ORACLE 11G

 - Column Name [TRIPID, EQUIPMENTNUMBER, SHIPDATE, LE, TRIPSTATUS, CREATEDATE, MODIFYDATE ]

Target Table [TRIP] - TERADATA

 - Column Name [TRIPID, EQUIPMENTNUMBER, SHIPDATE, LE, TRIPSTATUS, CREATEDATE, MODIFYDATE ]

Thanks

1 REPLY
Senior Apprentice

Re: Syntax error expected something like a name between ',' and the 'LE' keyword

The only way to use a keyword as a column name is double quoting it: "le"

You should check if there's a setting in Informatica to automatically enclose object names in double quotes.