BODS -Joining the tables from Oracle DB and SQL server DB is taking every long

Hi,

I'm using BODS 4.2 SP14 working on joining two tables form different databases which is taking very long to give the result.

I am trying to join a table from Source oracle DB with millions of records and another table which is in my staging SQL server DB which has only 10 records.

when I try to join these two tables in BODS it taking very long time to get the data from Oracle table for those 10 records.

I have tried different optimization techniques but still with no use.

Input
Table(SQL server - 10 records)
Table(Oracle DB - millions of records)

Querytransform(Join)

Output
Table(SQL server) - should be populated with the data from oracle table for those 10 records in SQL server Table.

Could you please help me with this.