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

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
balu124
Participant
Posts: 49
Joined: Wed Jul 25, 2007 9:53 pm

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

Post 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.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Define "performance" in an ETL context. Then maybe we can help you.

Hint: rows/sec is an almost completely meaningless metric.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”