I need to append data to existing Oracle Table with primark Key(Column1+Column2) using Oracle Enterprise Stage and the source is flat file,but i need to drop the records when i am appending the records when the primary key is already existing in the table.
What is the best way to design this scenario?
Any suggestions greatly appreciated.
Appending Data to Oracle Table using Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
no delete is required.
I do not want to delete the existing records, just append the new record and if the key exists just drop the record.Since we are using Index Rebuild option, it is is inserting all rows and failing to build the indexes.
Can we use any other design approach to skip the records upfront, before coming to Oracle Enterprise stage?
Can we use any other design approach to skip the records upfront, before coming to Oracle Enterprise stage?
Rao V
-
- Participant
- Posts: 135
- Joined: Tue Aug 14, 2007 4:27 am
- Location: Mumbai
Re: no delete is required.
Than u have to identify existing records... and as chulett mentioned should be identified before going to target ... use look up ....
otherwise ... enable index and use reject link logic ...
u can test both and find wt gives better performance.
otherwise ... enable index and use reject link logic ...
u can test both and find wt gives better performance.
Thanks
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
Swapnil
"Whenever you find whole world against you just turn around and Lead the world"
Look up with condition and drop worked
I tried with lookup and added a condition for key columns with "drop".It worked. thank you for all the support.
Rao V