1 Reply Latest reply: Dec 19, 2013 1:43 AM by Nick Gorman RSS

Question: How to make EDQ do UPDATE export instread of REPLACE export

S_Srisaksakul Newbie
Currently Being Moderated

Hi all


I am writting to ask about how to export as update in EDQ.


I am using EDQ 9.08.


I have notice that the export option that EDQ while doing the job setting is not contain UPDATE option.

Replace export option that has in EDQ with from my understanding after using it  is that it check for PK then delete the record and insert the new one.

,for example


then trying to export following data


What I get will be


instred of


(PK001 is a data in primary key attribute)


How can I make EDQ produce PK001,John,500 as the normal update will do?


I am facing a case of updating 20 million record into 50 million record in Oracle database. (contain autonum, seq and trigger)

Do i have to make a lookup before export  for that much number of record before update to make it updating to work?


I would be very appriciate for all information, I can get from you.

Thank you in advance


  • Correct Answers - 10 points
  • Helpful Answers - 5 points