Page 1 of 1

How to handle this type of job where reference file has morc

Posted: Fri Jan 18, 2008 5:49 am
by balu124
Hi ,
My reference file has 15million rows of data ,source file has 500 rows due to lack of cache for reference file the jobs gets aborted (source and referencs files are sequential files)

How to handle this situation for better performance.

Posted: Fri Jan 18, 2008 6:04 am
by ray.wurlod
Define "performance" in an ETL context. Then maybe we can help you.

Hint: rows/sec is an almost completely meaningless metric.