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

    Conditional replication


      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.



        • 1. Re: Conditional replication



          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.



          • 2. Re: Conditional replication

            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.