Oracle Connector - Oracle Bulk Load vs Insert

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
syedmuhammedmehdi
Participant
Posts: 43
Joined: Wed Feb 12, 2014 12:34 pm
Location: Hyderabad, India

Oracle Connector - Oracle Bulk Load vs Insert

Post by syedmuhammedmehdi »

Hi, I'm loading 21 million records in a Oracle table and it is taking around 1 hr 30 Minutes to load using Oracle Connector. I used Bulk Load as well as Insert Mode in Oracle. Surprisingly, in both modes Bulk as well as Insert Mode job is taking same time to load. More surprisingly Bulk mode is taking more time. Could you please advise what might be wrong in bulk mode?
SyedMuhammadMehdi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Are you certain it's actually performing a direct path bulk load? Without that specified and without meeting all requirements, sqlldr does conventional inserts.
-craig

"You can never have too many knives" -- Logan Nine Fingers
syedmuhammedmehdi
Participant
Posts: 43
Joined: Wed Feb 12, 2014 12:34 pm
Location: Hyderabad, India

Post by syedmuhammedmehdi »

Thanks Chulett for reply.Actually, after some debugging I came to know that there was no slowness caused by bulk load but before Oracle Connector I was using transformer in which I was calling Oracle Sequencer for surrogate key generator which was actually causing slowness. So, I removed surrogate key generation from transformer and used simple insert statement (without bulk load) in oracle connector with surrogate key next val.
SyedMuhammadMehdi
Post Reply