2 Replies Latest reply: Jun 11, 2014 6:37 AM by Frak!!! RSS

    Conditional replication

    user8686720
    user8686720 Jun 10, 2014 3:07 AM

      We have a requirement that purging activity carried at the source table should not get replicated to the target. The source table is a kind of staging table which get truncated every week, but the target table should not get impacted due to this truncate operation. Goden gate version we are using is 11.2.1 on Windows OS.

       

      Thanks

      • 387 Views
      • Tags:
        • 1. Re: Conditional replication
          J.A.
          J.A. Jun 10, 2014 2:31 PM (in response to user8686720)

          Hi

           

          Truncate is a DDL operation, do you have DDL replication enable ? in your OGG environment

           

          Maybe you need a historical table on your target DB, so maybe you can create a Job to copy the Data from the target table to the historical table.

           

          Regards

          • 2. Re: Conditional replication
            Frak!!!
            Frak!!! Jun 11, 2014 6:37 AM (in response to user8686720)

            you need to check if you have enable a DDL replication at the source database? if the DDL installed and enabled, you can control which DDL to capture from the extract and replicat by using DDL Include and DDL exclude parameters.