Page 1 of 1

Sequential file Reading

Posted: Wed Sep 10, 2008 12:53 am
by ravi123
Hi

How to reduce the Execution time.



seq file--------->transformer ----------------> oracle


my seq file contain 7 millions records, It take 8 hours to completed this job.

can you please give me the solution for Reduce the Execution time.


Thanks
Ravi

Posted: Wed Sep 10, 2008 1:34 am
by ray.wurlod
Get rid of the Oracle stage.

Posted: Wed Sep 10, 2008 7:49 am
by OddJob
Get rid of the transformer... any advance?