Home » Server Options » Replication » OGG unique identifier in target tables for CDC (Oracle Golden Gate)
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.

     
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: Stream Replication b/t 11g and 10 (merged)
Next Topic: Oracle Golden Gate extract date format
Goto Forum:
  


Current Time: Fri Nov 24 12:44:31 CST 2017

Total time taken to generate the page: 0.02265 seconds