Hi Experts,
I am facing a performance issue.
In my Job the Source is Sequential file and Target is Oracle Connector. The job has 2 Lookups and 2 Transformers in the Job design.
In QA:Job fetches records from source sequential file in 450 rows/sec
In Production:The same Job fetches records from source sequential file in 25 rows/sec
Nodes, number of source records are same in both situations.
How can I speed it up in Production.
Why it's fetching speed is low?
Thanks in advance,
Phani
Poor performance Sequential file to Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact: