Replicat issues - Update transformed into Insert is inserting 2 rows, 1 before image and 1 after ima
Hello
My GoldenGate environment is as follows:
Source: DB - 10.2.0.4
OGG - 11.2.0.1.25
Extract - Classic
Target:
DB - 12.1.0.2
OGG - 12.2.0.1.170221
REPLICAT - Integrated; Got the same results even after downgrading it to NON-Integrated and with a REPLICAT created as NON-Integrated.
All updates and deletes are converted into inserts by the replicat in the target DB. Hence, extract has the required parameters to capture the BEFORE IMAGES.
EXTRACT PARAMS :
TRANLOGOPTIONS INCLUDEREGIONID
TRANLOGOPTIONS LOGRETENTION SR
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES FETCHMISSINGCOLUMNS
GETUPDATEBEFORES
REPLICAT PARMAS:DBOPTIONS DEFERREFCONST
DBOPTIONS SETTAG 245867
DBOPTIONS INTEGRATEDPARAMS (COMMIT_SERIALIZATION FULL,
PARALLELISM 1) -- This was commented out when the replicat was downgraded to NON_INTEGRATED