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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Nov 1 2024
0 comments
93 views