I am a simple Senior Oracle DBA Consultant....

Oracle Certified (Database 9i/10g/11g
& Application 11i), dynamic, self-motivated and results-oriented
professional with over 16 years of broad- based experience in Database
Management, Administration, Backup & Recovery, Tuning and Oracle
Application Concepts and Architecture using Oracle Technologies (Database,
Oracle Application and Middleware). Expertise in high-technology time and cost
based solutions, quality customer service and commitment to excellence.

Thursday, December 1, 2011

Interesting in GoldenGate, I have requirement from a client to store the source transaction ROWID in target table. I have been through the documentation and reference guides, end up not finding anything interesting and stright forward. But managed to find the solution and here you go and enjoy,
It is managed by GG tokens, those who don't know GG, please refer the best Oracle Documentation
I have created the source extract parameter file with
TKN-ROW_ID = @GETENV("RECORD", "rowid")
and created my traget replicat process parameter file with
ROW_ID = @TOKEN("TKN-ROW_ID"))
It did the magic and I could see the target records as follows,
SCHEMA ROW_ID EMP_ID-------------------- ------------------------------ ----------SRC AACZoBAAXAAAACVAAF 550001334SRC AACZoBAAXAAAACVAAG 440001334SRC AACZoBAAXAAAACVAAH 2220001334SRC AACZoBAAXAAAACWAAA 990001334SRC AACZoBAAXAAAACWAAB 100001334SRC AACZoBAAXAAAACWAAC 70001334
Enojoy.....if you find this update useful....leave your comment.....

No comments:

Post a Comment