Oracle Connector - Oracle Bulk Load vs Insert
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 43
- Joined: Wed Feb 12, 2014 12:34 pm
- Location: Hyderabad, India
Oracle Connector - Oracle Bulk Load vs Insert
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
-
- Participant
- Posts: 43
- Joined: Wed Feb 12, 2014 12:34 pm
- Location: Hyderabad, India
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