Performance Tuning

praburaj · Post by **praburaj** » Wed May 04, 2011 2:29 am

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.

synsog · Post by **synsog** » Wed May 04, 2011 3:30 am

See this post..

viewtopic.php?t=117618&highlight=

soumya5891 · Post by **soumya5891** » Wed May 04, 2011 11:15 am

What kind option you are using in the load?

praburaj · Post by **praburaj** » Thu May 05, 2011 2:23 am

I am using upsert mode in my target table.

tbharathkumar · Post by **tbharathkumar** » Thu May 05, 2011 4:07 am

pls check there are any index created on the table, What is the remaining table space?