Oracle Bulk Loader

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
snt_ds
Premium Member
Premium Member
Posts: 280
Joined: Wed Oct 18, 2006 11:53 am
Location: Pune, India

Oracle Bulk Loader

Post by snt_ds »

Hi,

While I bulk load around 2 million records to an Oracle table, I have seen duplicate data, that violates the primary key, going into the table and the primary key itself gets disabled. I am told that DS is diabling the PK, loading the data and then trying to enable it. Is anyone aware of an issue with the ORACLE BULK stage?

syn_ds
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's the way it works. You are responsible for ensuring that no duplicates are sent to the load process so that the Primary Key constraint is not violated.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

what is the index mode you choose.
i will suggest you to read the parallel job developers guide---> oracle enterprise stage...
also search in this forum "for Oracle Bulk load"
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”