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.
then trying to export following data
What I get will be
(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