Hello,
I have an excel spreadsheet which has 5 Lac records and of size 37 MB ( It has roughly 78 columns). I am unable to create metadata for that file. Talend is throwing "Java heap space exception"
I need to process that file in couple of jobs. Please help.
Hi,
Your suggestion helped me.. Thanks a lot.
I have loaded individual files on to individual tables first and later on joined them later on. Thanks once again.
Just for information, file with large data got loaded only from UNIX box and only after increasing heap size in shell script file.
You can set any JVM parameters for the job in the Run view in the section JVM parameters. It is not necessary to edit the created shell scripts for this reason.
