probleme with the oracle bulk loader

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
bart12872
Participant
Posts: 82
Joined: Fri Jan 19, 2007 5:38 pm

probleme with the oracle bulk loader

Post by bart12872 »

Hello,

I use the orabulk to populate a table. but, when i have to idantical line, (Normally, it's an ORA-0001 error, primary key constraint violation), I don't know if it's Datastage or oracle, but my constraint is desactivated and the two lines are insert.

How can I reject those lines using the orabulk stage ?

thanks,
bart.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Oracle thing. And you can't. You need to ensure you do not have data to be bulk loaded that would violate any constraints.
-craig

"You can never have too many knives" -- Logan Nine Fingers
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Re: probleme with the oracle bulk loader

Post by narasimha »

You need to rectify the primary key constraint violation problem before you can bulk load into that table.
Not sure if you can reject these lines using the orabulk stage
Narasimha Kade

Finding answers is simple, all you need to do is come up with the correct questions.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Nop. No rejects from that stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply