Skip to Main Content

GoldenGate

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!

Filtering out updates on certain column

MiumiuNov 1 2024 — edited Nov 1 2024

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.

Comments
Post Details
Added on Nov 1 2024
0 comments
242 views