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,
The GoldenGate forum is over here: GoldenGate
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.