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

PK001,Jame,500

then trying to export following data

PK001,John

What I get will be

PK001,John,NULL

instred of

PK001,John,500

(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

Legend

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