Hi,
I have job like this
Seq---->Transformer---->OracleStage.
I have a file which has 1,50,000 records. I have loaded the data successfully in the target table But the problem is It has taken more than 10 minutes to load the data. People here rejected the job. How to reduce the load timing in the target table. It is a very simple design. I don't have a idea how to improve the performance. If any one have any Idea, Please give me your valuable suggestions.
Performance Tuning
Moderators: chulett, rschirm, roy
Performance Tuning
prabakaran.v
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 26
- Joined: Mon Aug 27, 2007 6:27 am
- Location: Des Moines