Skip to main content

Append Staging

The string to append to the Data Mart staging object names.

When the Data Mart load stages data in the same database as the target object, the staging object's name is derived from the target name with this value applied (appended or prepended per Suffix Or Prefix Object), keeping the staging and target objects distinct. The value is also available as the @@stage token in Object Name Patterns.

When to Change This Setting​

Change it to match the naming convention of the solution, for example Stage for PascalCase names instead of the upper-case default.

SettingInteraction
Suffix Or Prefix ObjectDetermines whether the affix is appended or prepended
Append DimensionThe affix for Dimension objects
Append FactThe affix for Fact objects

Notes​

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