Column Separator
Specifies how naming parts for columns are combined, primarily used by the Accelerator. The default setting is an underscore, which we recommend keeping for consistency.
When the Accelerator derives key column names, it places this separator between the name and the column affix, such as the Append Integration Key or Append Surrogate Key affix. Suffix Or Prefix Column decides whether the affix comes after or before the name. The Dimensional Accelerator takes its column separator from the same setting.
Outside the Accelerator, the Generate Integration Key dialog uses the separator to name the new key column. Business Modeling uses it for the default Integration Key attribute of a Business Entity, which combines the entity's technical name, this separator and the Append Integration Key affix. Business Modeling uses an underscore when the setting is absent.
When to Change This Setting
Keep the default underscore unless your naming standard joins column name parts with a different character. Set it before accelerating or modeling, because the separator is written into the names when they are created.
Related Settings
| Setting | Interaction |
|---|---|
| Suffix Or Prefix Column | Determines whether the column affix is appended or prepended |
| Append Integration Key | The affix joined to derived Integration Key names |
| Append Surrogate Key | The affix joined to derived surrogate key names |
| Object Separator | The equivalent separator for object names |
Notes
- This setting is part of the Naming settings category.
- The default value for this setting is
_.