Join Two Tables from different databases in one Source Query

[sarathi]

I have requirement to Join tables - multiple SQL Server tables with joins to ONE Oracle table with LIKE condition in ODBC Plug-in. I tried giving Oracle DB name in query and getting Invalid object name error.

Query in ODBC SQLServer connection -

select Asset, Tag from asset
join SQLSERVER.Portfolio on SQLSERVER.tid = SQLSERVER.tid
join ORACLE.LOCATION on ORACLE.LOCATION.code LIKE SQLSERVER. code

I'm not insisting on using two separate sources -one for SQLServer and other Oracle.

Thanks in advance

Sarathi

[ArndW]

Since the Oracle and SQL Server database are distinct from each other, you will need to use 2 source stages and perform the join in DataStage.