Skip to main content

Stage Column With Business Name

When defining a Business Name for a Column in the Business Overrides section, setting this to true will use the Business Name as the staging column name.

When disabled, the staging layers keep the original source column names and Business Names take effect from the Data Vault and Data Mart layers onward. When enabled, columns with a Business Name carry it from the staging tables onward, and the generated staging load SQL maps the renamed columns accordingly.

When to Change This Setting​

Keep the default N to preserve source column names in staging, which keeps the staging tables directly comparable with the source system. Enable it when business naming should be established as early as the staging layer.

SettingInteraction
Stage Object With Business NameThe equivalent control for staging table names

Notes​

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