OraFAQ Forum: Replication » OGG unique identifier in target tables for CDC

Home » Server Options » Replication » OGG unique identifier in target tables for CDC (Oracle Golden Gate)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OGG unique identifier in target tables for CDC [message #656401]

Wed, 05 October 2016 05:07

manjari1234
Messages: 3
Registered: June 2014
Location: India

Junior Member

Need help to uniquely identify records in Oracle Golden Gate target tables. I am using OGG for change detection where every insert/delete in source table insert a record in target table and for every update it insert two records in target tables as before and after. Now i need unique identifier for every insert/delete/update and two record which was updated should have same identifier.

For easy understanding i am posting below table. I need unique identifier which can be @GETENV ('RECORD', {'FILESEQNO'|'FILERBA'|'ROWID'|'RSN') or @GETENV ('GGHEADER', {'LOGPOSITION'| 'LOGRBA'}) . But i am not able to understand which is correct one as per my requirement as LOGPOSITION,RSN repeating.FILERBA was different for BEFORE and AFTER value in case of update.I am ready to use combination of two value as well. But identifier should not repeate and its needs to be unique.

Code: [Select all] [Show/ hide]

     
EMP_ID	DEPT_ID	EMP_NAME	TRAN_TYPE	BEFORE_AFTER	UNIQUE IDENTIFIER
100	1067	Reshma	       SQL COMPUPDATE	BEFORE	        IDENTIFIER-1
100	956	Reshma	       SQL COMPUPDATE	AFTER	        IDENTIFIER-1
300	953	Adir	       SQL COMPUPDATE	BEFORE	        IDENTIFIER-2
300	953	Adira	       SQL COMPUPDATE	AFTER	        IDENTIFIER-2
500	1067	Suhani	       INSERT	        AFTER	        IDENTIFIER-3
600	857	Raj	       SQL COMPUPDATE	BEFORE	        IDENTIFIER-4
600	345	Raj	       SQL COMPUPDATE	AFTER	        IDENTIFIER-4
800	907	Basant	       DELETE	        BEFORE	        IDENTIFIER-5

[mod-edit: code tags added by bb]

[Updated on: Wed, 05 October 2016 17:15] by Moderator

Report message to a moderator

Previous Topic:	golden gate replication to partitioned table
Next Topic:	Stream Replication b/t 11g and 10 (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 11 21:09:01 CDT 2025