We have some ETL processes that currently use RSID$ to keep track of the latest transaction. We are switching over to GoldenGate and need to replace the RSID$ with an equivalent.
What would be an alternative to RSID$ in goldenGate?
Can we use pos? (pos-The concatenated sequence number and the RBA number from the source trail file. This trail position lets you trace the operation back to the source trail file. The sequence number is the source trail file number. The RBA number is the offset in the trail file)
Appreciate any suggestion or comments.