1 Reply Latest reply: Sep 13, 2011 10:03 AM by stevencallan RSS

    Hi . Help Needed

    Efficientoracle
      Hi,
      Am New to Oracle Golden Gate. Need Help .

      Oracle 11.2.0.2

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