Skip to main content

Append Schema

The string to add to the PSA objects when Staging and Persistent Staging are co-located in the same database.

The affix is only applied when the Staging and Persistent Staging connections point at the same database catalog, so that the PSA table names do not collide with the staging table names. Whether the string is appended or prepended follows the Suffix Or Prefix Object setting, and a blank value falls back to ods.

When to Change This Setting​

The default ods gives co-located PSA tables an ods-affixed name. Change it to match your naming convention for the persistent layer; it has no effect when Staging and Persistent Staging use separate databases.

SettingInteraction
Suffix Or Prefix ObjectDetermines whether the affix is appended or prepended
Append Schema STGThe equivalent affix for Staging objects

Notes​

  • This setting is part of the Staging Persistent settings category.
  • The default value for this setting is ods.