Job :
File -----> Oracle Stage
In oracle stage , using upsert method.The insert query is fine , then in the update query we need to update rest of the columns of previous record if column A and B values of new records matches with the old record column A nd B values.
In this case duplicates are generated as old record is completely updated for new record with same value of A and B.
How to deal with it. I have tried both options of Insert Then Update and Update then Insert
Inserting new records in the table creating duplicates
Moderators: chulett, rschirm, roy
-
amreesh_singh
- Participant
- Posts: 15
- Joined: Tue Aug 26, 2008 5:07 am
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: