1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need help identifying unique identifiers in oracle golden gate replication

Discussion in 'General' started by Manjari, Oct 5, 2016.

  1. Manjari

    Manjari Newly Initiated

    Messages:
    1
    Likes Received:
    1
    Trophy Points:
    40
    Location:
    India
    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.




    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
     
    sneha singh likes this.