GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GG: Join user records with the audit records (aud$) associated with the modification.

edited Mar 23, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hi: I need to join user records with the audit records (aud$) associated with the modification.

Using a token, I can add the transaction_id to user Table (format is fiferent from GG that from aud$, but I know how to modify).

But if  transaction has many statements, I need more fields in the join.

Any idea on those fields to add to join?.

I tested the scn, offset inside trial, record timestamp, etc and no one solves the problem. Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center