Skip to main content

Default Schema

The default schema to use for the Data Mart in the Accelerator.

Dimension and Fact objects derived by the Dimensional Accelerator are created in this schema unless a more specific schema override resolves for the object type. When the setting is blank, dm is used.

When to Change This Setting

Change it when the presentation layer uses a different schema name than the dm default.

SettingInteraction
Schema DimensionOverrides this schema for Dimension tables
Schema FactOverrides this schema for Fact tables
Default SchemaThe equivalent default schema for the Data Vault Accelerator

Notes

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