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