Skip to main content

Schema Point In Time

Override the Default Schema used in the Create Point In Time dialog.

When set, Point-In-Time tables created through the dialog are placed in this schema. When blank (the default), the new Point-In-Time table takes the schema of the Hub or Link it is created from.

When to Change This Setting

Set it when Point-In-Time tables should live in a dedicated schema (for example a presentation or query-assistance schema) rather than alongside their source Hub or Link.

SettingInteraction
Append Point In TimeThe naming affix for the created Point-In-Time table
Schema BridgeThe equivalent override for the Create Bridge dialog
PIT Add Surrogate KeyThe key structure of the created Point-In-Time table

Notes

  • This setting is part of the Data Vault Naming settings category.