Please help on this.
1 person found this helpful
Its a bit tricky, because any update is going to cause the PK to go into the redo (which you can't exclude in the Extract configuration). Therefore if you want to exclude updates to a row where no columns of interest are updated, you have to start building up that logic yourself.
One way to do this is to have a filter on Extract something like this -
FILTER (ON UPDATE, @COLTEST(COL2,PRESENT,NULL)
Then, if COL1 is your PK and COL4 is the column you want to ignore then Extract will only pull records where one of the other columns has also changed.
So you have to list all of the columns that you DO want to trigger an extract for.
Does that make sense?