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

    Conditional replication

    user8686720

      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

        • 1. Re: Conditional replication
          J.A.

          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!!!

            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.