Uniform Change Type
When enabled, this setting ensures uniform handling of all source inserts and updates. Specifically, if the only difference between records is the RowChangeType, a new record won't be inserted. This prevents unnecessary duplication and maintains a cleaner history of attribute changes.
In the generated Satellite comparison, the change type value is normalized before hashing (insert (I) and update (U) markers are treated as the same value) so a row whose attributes are unchanged does not register as a delta merely because the source flagged it differently. This applies to Satellites, Link Satellites and Reference tables that carry a change type attribute.
When to Change This Setting
Keep the default N when the distinction between source inserts and updates is meaningful history you want preserved. Enable it when sources re-deliver rows with fluctuating insert/update markers (for example CDC feeds replaying data), to keep the Satellite history limited to genuine attribute changes.
Related Settings
| Setting | Interaction |
|---|---|
| Delta Collapse Rows | Complementary de-duplication that removes consecutive rows with identical attribute hashes |
Notes
- This setting is part of the Data Vault settings category.
- The default value for this setting is
N.