Suppressing the apply of row operations

You can suppress an insert, update, or a delete from replicating to the target table.

Before you begin

This feature is not available for the CDC Replication Engine for Netezza® Technology or the CDC Replication Engine for InfoSphere® DataStage® (Cloudant, Flat Files, or Hadoop). For the CDC Replication Engine for Kafka, you can develop a user-defined Kafka custom operation processor to implement this feature.

About this task

Use the Operations tab to suppress an insert, update, or a delete from replicating to the target table. You may decide to suppress row-level operations from replicating to a target table if you have a target-side application on which you do not want any updates or deletes to occur. For example, if your target-side application is a data warehouse, you may only want inserts to occur on your data warehouse tables or other third party applications.

You can suppress operations if you mapped tables using either Standard or Adaptive Apply replication.

Procedure

  1. Click Configuration > Subscriptions.
  2. Select the subscription.

    Ensure that the subscription contains a table mapping that was mapped using Standard or Adaptive Apply.

  3. Select the table mapping in the Table Mappings view.
  4. Right-click and select Open Details....
  5. Click the Operation tab.
  6. Choose one or more of the following options:
    Do not insert
    Prevents CDC Replication from applying an insert to a mapped target table. This does not apply to the CDC Replication Engine for Netezza Technology.
    Do not update
    Prevents CDC Replication from applying source update operations to a mapped target table. This does not apply to the CDC Replication Engine for Netezza Technology.
    Do not delete
    Prevents CDC Replication from applying a delete to a mapped target table.
  7. Click Save.

Results

Depending on your selections, when you start replication, CDC Replication does not apply the row operation.