How to read a query pointing to different tables of different source systems in Talend.

[Swapna1]

Can we read query pointing to different tables of different source systems?

Eg. select * from oracle1.dbo.tableA inner join SqlServer1.temp.tableB inner join

oracle2.dbo.tableC inner join SqlServer2.temp.tableD

[manodwhb]

@Swapna K​,you need to read take four tDBInput components to read those four table separately and join using tMap.

Thanks,

Manohar