Hi folks
I have this issue:
My SOURCE is a MS SQL Server 2000 instance and my TARGET is Oracle 12g
I am using mapping, and I want to map this table "ICACCT" from the SQL Server to same table in Oracle database
But it doesnt even let me to Validate my mapping and when I hit validate, it throws this error:
A parse error was encountered when parsing the expression: ICACCT.DESC. The default parser supports ANSI SQL delimiter.
If a non-standard syntax is desired, use the free-form expression delimiters /%% and %%/ around the expression
I know DESC is a reserved word in SQL Server and you cannot query like this : "SELECT DESC FROM TABLE" unless you put it between bracket []
How can I resolve this issue? is there any way to tell ODI to use aliases for this? (DESC as DESCRIPTION)
I really appreciate your help,