Conflict resolution audit table

Conflict detection and resolution lets you detect, log, and act on inconsistent data on the target.

When CDC Replication resolves a conflict between the source and target tables, it records information about the resolution in the table. CDC Replication creates this table in the target metadata location that is specified during the configuration of CDC Replication.

Note: CDC Replication will add data continuously to the audit table as conflicts occur, but will never purge data from the table. Depending on the number of conflicts, the audit table will to grow in size over time. It is the user's responsibility to schedule maintenance (such as using a DELETE FROM statement) on the conflict resolution audit table regularly. A good practice would be to remove the applicable information from the audit table after you have resolved each conflict.