DSXchange

Posted: **Wed Apr 27, 2011 12:13 pm**

In my target i used upsert option. for 50000 records it tooks 10 minutes.
but the same job i designed in server and it took 2 minutes.
The design of the job is :

oracle --> transformer ..> oracle

Please suggest why parallel is taking more time

Posted: **Wed Apr 27, 2011 3:09 pm**

Probably something to do with the multiple nodes contending with each other. Does your partitioning guarantee that each key value can occur on only one node?

Posted: **Thu Apr 28, 2011 1:19 am**

Use loading as sequential method

Posted: **Thu Apr 28, 2011 1:40 am**

What's the point of buying a parallel execution engine then?!!!!

Sampath wrote:Use loading as sequential method

Extremely poor advice, in my opinion.

Posted: **Thu Apr 28, 2011 3:57 am**

I used hash partiotiong this time job aborted.

Operator terminated abnormally: received signal SIGSEGV

DSXchange

upsert is taking long time

upsert is taking long time