Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

S_SrisaksakulDec 19 2013 — edited Dec 19 2013

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2014
Added on Dec 19 2013
#data-quality, #master-data-management-mdm
1 comment
1,219 views