Create Persistent View
Enables the creation of SQL Views to query data from the Persistent Staging Area (PSA), simulating Staging Tables. This feature facilitates full reload processing of your Data Vault tables.
The views are created per source object in the staging schema, named with the persistent view prefix followed by the staging table name, and select the staged shape of the data from the PSA. Views are only generated for objects with a Persistent Staging connection; Staged Objects and objects marked as not persistent are skipped, and for SSIS projects the views require Pushdown Processing.
When to Change This Setting
Keep the default N unless you reload Data Vault (or other downstream) tables from the PSA, in which case the views provide staging-shaped sources for the reload without re-extracting from the source systems.
Related Settings
| Setting | Interaction |
|---|---|
| Prefix Persistent View | The prefix used in the view names |
| Row Hash Persistent View | Controls whether the views expose the row hash |
| Persist History | Whether source data is persisted to the PSA at all |
Notes
- This setting is part of the Staging settings category.
- The default value for this setting is
N.