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.
Table(SQL server - 10 records)
Table(Oracle DB - millions of records)
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.