DSXchange

Posted: **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.

Posted: **Wed May 04, 2011 3:30 am**

See this post..

viewtopic.php?t=117618&highlight=

Posted: **Wed May 04, 2011 11:15 am**

What kind option you are using in the load?

Posted: **Thu May 05, 2011 2:23 am**

I am using upsert mode in my target table.

Posted: **Thu May 05, 2011 4:07 am**

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

DSXchange

Performance Tuning

Performance Tuning