AnsweredAssumed Answered

How to handle huge(50 lakhs) record in pentaho

Question asked by Premkumar Manipillai on Aug 29, 2018
Latest reply on Sep 17, 2018 by Marin Botev

Dear all,

 

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.

oracle_sql.jpg

 

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.

 

Thanks

Outcomes