You are not logged in.

#1 2012-03-19 18:05:19

srividya
Member
5 posts

tfileInputExcel with excel2007 format read issue

hi there,

Is there a limit on tfileinputexcel on number records to be read?
i have 170000 records to be read from xlsx and even after increasing memory job is failing with - OutofMemoryError.

tfileinputexcel is the first component of my job. Any help?

Memory specified - 5gb

Thanks,
Srividya

Last edited by srividya (2012-03-20 11:06:24)

Offline

#2 2012-03-21 07:25:17

pedro
Member
3682 posts

Re: tfileInputExcel with excel2007 format read issue

Hi

You can increase the values in the following image.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-03-27 10:02:07

slenk
Talend Team


Re: tfileInputExcel with excel2007 format read issue

Hi.
I would rather save the *.xls/-x as *.csv and process it with tFileInputDelimited. Why? Have a look at the number of rows processed - you will be 4+ times faster.
HTH


Talend - simply great!!!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy