Historization
Configures historization and persisting behavior.
Use this page to find the Historization settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| Hist Default Type | HIST_DEFAULT_TYPE | 2 | 1- SSIS Package, 2 - Stored Procedure. |
| Hist Default Use Vaultid | HIST_DEFAULT_USE_VAULTID | 1 | 0 - don't use VAULT_HUB_ID as primary key. 1 - use VAULT_HUB_ID as primary key. |
| Hist Do Not Close | HIST_DO_NOT_CLOSE | 0 | Default value of "Missing record behaviour" parameter for new historizations. 0 - close, 1 - don't close. |
| Hist Empty Record Field Name | HIST_EMPTY_RECORD_FIELDNAME | IS_EMPTY_RECORD | Name of the column to identify empty records in the historized tables. |
| Hist Proc Use Hash Join | HIST_PROC_USE_HASH_JOIN | 1 | Use HASH JOIN hint in historizing SP to speed up SQL EXCEPT command. 0 - No, 1 - Yes. |
| Hist Proc Use No Lock | HIST_PROC_USE_NOLOCK | 1 | Use NOLOCK hint in historizing stored procedures: 0 - No, 1 - Yes. |
| Hist Valid To Mode | HIST_VALID_TO_MODE | 0 | Subtract 2 milliseconds from the valid-to date: 0 - Yes, 1 - No. |
| Pers Default Part Switch | PERS_DEFAULT_PARTSWITCH | 2 | 0 - None, 1 - Partition Switching, 2 - Renaming. |
| Persist Num Attempts | PERSIST_NUM_ATTEMPTS | 5 | Number of attempts to persist transformation in persisting stored procedure. |
| Persist Pause Between Attempts | PERSIST_PAUSE_BETWEEN_ATTEMPTS | 00:00:10 | Pause between attempts to persist transformation in persisting stored procedure. Format: HH:MM:SS. |
| Persist Use Transactions | PERSIST_USE_TRANSACTIONS | 1 | Use transactions in persisting procedures. 0 - No, 1 - Yes (default). |
