i need to fetch huge(50 lakhs+) record from oracle db and insert in to ms sql server db.
Is there any option in pentaho 8.1 ETL community version? or any other solutions for this. Please guide me.
i connected "Oracle db" with "ms sql server db" and fetching & inserting up to 1 lakhs record successfully using bellow oracle query.
SELECT * FROM MASTER_TABLE M WHERE ROWNUM<=100000
If i using the above query without having WHERE class it will be hang. right?
kindly any one replay for this.