| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
