DSXchange

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

Did you check the server load in your production environment? Are there other jobs running at the same time, using more memory which might be affecting this job's performance?

Change your output stage to a PEEK stage and compare performance between the environments. I am willing to bet that the difference is in your database writes.