Starting with Generators 2.0 releases, the Delta Detection Property is available on the Model Object Properties. Until then, it was available on the Project Settings.
Check Delta Detection (Project).
Description
The Delta Detection Property is available when you edit a Model Object.
You can configure how comparisons are performed between records in the delta detection for SCD2 Terms, for example.
Format
The Delta Detection is a List of values.
The available options are:
- Hash Value Comparison:
- Comparisons are done thanks to the hash value of each record stored in a Default Column (BG_RowHash, BG_RowHashScd1, or BG_RowHashScd2)
- Column Comparison:
- Comparisons are done column by column
Example:
Default Value
The default value is Hash Value Comparison.