We are working with GG23ai, Oracle to Oracle. We have a source table with +200 columns and they are all moved to target. Now in the source system there is a process that updates one date column, let's call it DT1. I have tried several ways in extract to filter out updates on the column but either I get all data anyway or I don't get anything. If I change the filtering column to be any of the varchar2 columns, it works (but it's not an option because of other reasons). So what do I need to get it working with date column? Or should I try to filter it in replicat side? Am I just thinking this with some twisted logic and filter condition? :D
My latest trial looks like this. The process is the only thing touching DT1 so if DT1 is not changed (but something else is), update is ok. But I don't get any data to target with this.
GETUPDATEBEFORES
TABLE A.MY_TABLE, FILTER (@BEFORE(DT1)=@AFTER(DT1));
PS: Colsexcept is not an option; it just brings the date column as empty to target but doesn't limit the updates anyway.