1 Reply Latest reply on Sep 13, 2011 3:03 PM by stevencallan

    Hi . Help Needed

      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,
        • 1. Re: Hi . Help Needed
          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.