You are not logged in.
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
Last edited by srividya (2012-03-20 11:06:24)
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.