DSXchange

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.

You can use reject link to capture records failing with unique key constrain .... perform delete and then insert ...



hope this help ?

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?

Then you need to not send them to the target, and that would typically mean a lookup against the target and only pass the records that 'fail'. Assuming your duplicates are not in your load data, that is.

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.

I tried with lookup and added a condition for key columns with "drop".It worked. thank you for all the support.