O
O
Oleg Aksenov2019-03-06 10:55:55
Oracle
Oleg Aksenov, 2019-03-06 10:55:55

How to overwrite an entry in Golden Gate if it exists?

Good afternoon, please tell me with the following question,
In Oracle Golden Gate, you need to handle an error using RESOLVECONFLICT, for example, I'm trying to insert a row whose value in one of the columns is 100 or 101, it already exists and needs to be overwritten or skipped if already exists, I found the processing of the column
in the instruction , but how can I process not the whole column, but process if it has a certain value?
I tried to add the following to the EXT group (./ggsci edit params ext1):

MAP TABLE.src, TARGET TABLE.trg,
  COMPARECOLS
  (ON UPDATE ALLEXCLUDING (column)),
  RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE (column)),
  RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE (column))),
  );

Thanks in advance for your replies

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question