Hi Pentaho Gurus-I have a sql queries with lot of joins with record count of 9 lakhs per day. i want to extract it from another server to my local server.
Will pentaho support to extract this huge data? if yes, what are the prerequisites that i have to install ?
if it extracts how much time will it consume to extract the file as .txt?
Server configuration is 2 core 32 GB RAM.
Need you suggestions/support on this.