Skip to main content

Add Row Hash Key Index

Enable to add a unique, non-clustered constraint on the FlexRowHashKey and EffectiveFromDate columns in staging tables. The FlexRowHashKey is the hash value covering the Integration Key.

Example:

CONSTRAINT [UK_<schema>_<table>_FlexRowHashKey] UNIQUE NONCLUSTERED
(
[FlexRowHashKey] Asc,[FlexRowEffectiveFromDate] Asc) WITH (PAD_INDEX = OFF,IGNORE_DUP_KEY = OFF) ON default
)

Notes:

  • This setting is part of the Staging settings category.
  • The default value for this setting is N.