Need to implement Goldengate Audit as that of Streams CDC
@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
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
0