Skip to main content

Prefix Surrogate Key

Should we prefix the Hubs and Links Surrogate Keys.

Controls whether the object-type affix (Append Hub / Append Link) is included in the surrogate key column names the Accelerator derives. When it applies, the key name is derived from the Business Name combined with the object affix before the Append Surrogate Key affix is attached; otherwise the key name is derived from the Business Name alone.

Options: Links, Hubs & Links, None

OptionBehavior
Links (default)Link keys include the Link affix (LNK_Customer_Order_SK); Hub keys do not (Customer_SK)
Hubs & LinksHub and Link keys both include their object affix (HUB_Customer_SK, LNK_Customer_Order_SK)
NoneNeither includes the object affix (Customer_SK, Customer_Order_SK)

When to Change This Setting​

Keep the default Links to keep Hub key names compact while still distinguishing a Link's own key from the Hub reference keys it contains. Use Hubs & Links when every key name should carry its object type, or None for the shortest key names, noting that a Hub and a Link sharing a Business Name would then derive identical key names.

SettingInteraction
Append Surrogate KeyThe surrogate key affix attached to the derived name
Append HubThe Hub object affix included when Hubs are selected
Append LinkThe Link object affix included when Links are selected
Suffix Or Prefix ColumnDetermines whether the surrogate key affix is prepended or appended

Notes​

  • This setting is part of the Data Vault Naming settings category.
  • The default value for this setting is Links.