Delta Use Hash Diff
Enable this option to use Hash Diff comparisons for Change Data Capture and Change Tracking sources. This method provides a more robust way to identify and capture only the changes, but may increase load time.
For CDC sources with this setting disabled, the row hash system columns are not included on the Staging and PSA tables and delta row collapsing is skipped: the change stream delivered by the source is applied as-is instead of being re-compared by hash.
When to Change This Setting
Keep the default Y so CDC and Change Tracking deltas are verified with a hash comparison before they are persisted. Disable it to trust the source change stream directly and shorten the load.
Related Settings
| Setting | Interaction |
|---|---|
| Delta Collapse Rows | For CDC sources, row collapsing only applies while hash diff comparison is enabled |
Notes
- This setting is part of the Staging Persistent settings category.
- The default value for this setting is
Y.