Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Sep 13, 2011 10:03 AM by
Hi . Help Needed
Sep 13, 2011 12: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,
This content has been marked as final.
Show 1 reply
Re: Hi . Help Needed
Sep 13, 2011 10:03 AM
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.