Skip to main content

Append Identity

The string used to derive key column names when cloning an object with the Add Identity Column option.

When an object is cloned, columns that reference another cloned table's identity key are mapped to that table's new primary key name where the names can be matched. A referencing column whose name cannot be matched to the key naming patterns is renamed to {column name}_{this value} in the clone (for example Customer becomes Customer_Key). When the setting is blank, Key is used.

The name proposed for the identity column itself in the clone dialog is derived from the object name and type (Key/KEY for Dimensions and Facts, _SK for Satellites, Id/ID otherwise) and can be edited before cloning; it does not use this setting.

When to Change This Setting​

Change it when the derived reference-key column names should follow a different convention than the _Key default.

SettingInteraction
Append DimensionThe naming affix for Dimension objects
Append FactThe naming affix for Fact objects

Notes​

  • This setting is part of the Data Mart settings category.
  • The default value for this setting is Key.