Preventing the audit of row operations

You can prevent row operations from being audited

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 prevent CDC Replication from the auditing of row operations. If you have mapped your tables using LiveAudit, then CDC Replication audits row level operations taking place on the source.

Procedure

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

    Ensure that the subscription contains a table mapping that was mapped using LiveAudit.

  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 auditing an insert to a mapped target table.
    Do not update
    Prevents CDC Replication from auditing an update to a mapped target table.
    Do not delete
    Prevents CDC Replication from auditing a delete to a mapped target table.
  7. Click Save.