I am trying to join two tables . One table is from oracle and other is from db2. I am getting parsing error :
TEIID31100 Parsing error: Encountered "db2.id=ora.id [*]_[*]__" at line 7, column 1.
Lexical error. Character is not a valid token: _
And query written by me is :
FROM New_DB2_for_Linux_UNIX_and_Windows_2_.emp db2 , New_Oracle_3_.emp ora
info abt table:
New_DB2_for_Linux_UNIX_and_Windows_2_.emp is data source from db2
and New_Oracle_3_.emp is data source from oracle databases.
Can anybody give suggestion to overcome from above problem.
The above error and your query you posted not looking the same. Do you have other characters at the end. Also, where did you write the query? In the transformation editor?
If you want you can attach Designer project file I can take a look.