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.

No BEFORE images with PK UPDATEs

martin.wendlerNov 29 2024

Hi,

I'm trying to replicate tables from Oracle to Snowflake.

As I want to keep the history for the table, I also want to get BEFORE and AFTER images for PK UPDATEs.

Unfortunately, I'm getting only AFTER images.

These are the parameters for EXTRACT:

FETCHOPTIONS FETCHPKUPDATECOLS
GETUPDATEBEFORES
NOCOMPRESSUPDATES
NOCOMPRESSDELETES

There are the parameters for REPLICATE:

ALLOWDUPTARGETMAP
INSERTALLRECORDS

AllowNoopUpdates
ASSUMETARGETDEFS
Insertmissingupdates
HandleCollisions
GETTRUNCATES
GETUPDATEBEFORES

Kind regards,

Martin

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 29 2024
1 comment
99 views