GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Need to implement Goldengate Audit as that of Streams CDC

edited Oct 3, 2013 4:24AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered
@GETENV (“GGHEADER”, “OPTYPE” retuns any one of below values :
INSERT
UPDATE
DELETE
ENSCRIBE COMPUPDATE
SQL COMPUPDATE
PK UPDATE
TRUNCATE

On comparing to streams cdc we get Operation$ as I,UO,UN,D for insert,update(before),update(after),delete.
In goldengate we have @GETENV (“GGHEADER”,"beforeindicator") to say if its before or after image

So if @GETENV (“GGHEADER”, “OPTYPE”)=Insert ,i need to return I
if @GETENV (“GGHEADER”, “OPTYPE”)=SQL COMPUDATE or PK UPDATE and "beforeindicator"=after, i need to retun as UN
if @GETENV (“GGHEADER”, “OPTYPE”)=SQL COMPUDATE or PK UPDATE and "beforeindicator"=before, i need to retun as UO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center