Java Heap Space Issue in Talend while processing large xlsx file
Hello All, I have huge xlsx file with having more than 700000 records and more than 100 columns in it. I have to read the file and load it into the table but I am facing Java Heap Issue. Can some one please let me know what is the limitation of Talend and upto what size of records I can process in Talend using xlsx file and also size of file matters to cause the java heap space issue. and if it is then what would be the maximum size allowed. Basically what is the limitation of Talend for processing large xlsx file and what is the solution for it. Thanking you, with kind regards, Akash Sonawane.
Re: Java Heap Space Issue in Talend while processing large xlsx file
Hi, Have you tried changing the 'Generation Mode' option in the Advanced settings of the tFileInputExcel component to 'Less memory consumed for large excel(Event mode)'? That fixed a similar issue i had. Regards, Aled