Controlling table operations
You can control table operations during a refresh.
By default, CDC Replication truncates the target table in response to a table-level clear or refresh operation. You can control this so that CDC Replication preserves all or some of the rows.