Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Database + Options
This discussion is archived
on Sep 13, 2011 3:03 PM by stevencallan
Hi . Help Needed
Sep 13, 2011 5:19 AM
Am New to Oracle Golden Gate. Need Help .
I have 3 tables In Source Database.
I have to Join those 3 tables and Insert One record into a table in my Target database .
Is It Advisable and how it can be done?
Your Help Is Highly Appreciated.
Thanks & Regards,
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Hi . Help Needed
Sep 13, 2011 3:03 PM
in response to
The GoldenGate forum is over here:
If your DML operation on the source results in an insert on a table in the source, then the same thing would take place on your target, assuming you have the same tables and data.
If you are looking at this as a form of ETL, then your triggering event on the source can be captured in the target's Replicat and processed using SQLEXEC.