dc_settings: Data Cache Settings
read only
- Catalogue :
Cache - Schéma :
Invantive - Clés primaires :
stg_id - Label: Settings
Central configuration of the software consisting of settings and defaults for configuration of other objects such as tables.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table dc_settings sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
stg_ |
varchar2 |
Autoriser la mise à jour automatique | Whether the repository data model must be checked for an upgrade (and executed when deemed necessary) on every new connection to the backing database. | ||
stg_ |
varchar2 |
Mise à jour automatique unique | Whether the repository data model must be checked for an upgrade (and executed when deemed necessary) on the next connection established to the backing database. | ||
stg_ |
varchar2 |
Créé dans | The code of the function in the modules table from within which the user created the record.This value will never change after creation of the record. | ||
stg_ |
varchar2 |
Crée par | Qui a établi ce record ? | ||
stg_ |
datetime |
Créé le | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
stg_ |
datetime |
Mise à jour à | The system time in UTC at which the record was last updated.This value will change for every mutation of the record. | ||
stg_ |
varchar2 |
Dummy | Placeholder for a unique value to ensure uniqueness and at most one row in this table. | ||
stg_ |
varchar2 |
Identifiant d'environnement | Unique environment ID. | ||
stg_id |
decimal |
ID | Unique identifier. | ||
stg_ |
char |
Index, faits et tables | Default whether indexes on facts tables must be created and maintained. | ||
stg_ |
char |
Tableaux d'historique des indices | Default whether indexes on history tables must be created and maintained. | ||
stg_ |
char |
Gérer les vues logiques globales | Default whether overall logical views must be created and maintained. | ||
stg_ |
varchar2 |
Nom de la vue logique globale de Postfix | Default postfix for the name of the overall logical view. | ||
stg_ |
varchar2 |
Préfixe - Nom de la vue logique globale | Default prefix for the name of the overall logical view. | ||
stg_ |
char |
Gérer les vues logiques des partitions | Default whether partition logical views must be created and maintained. | ||
stg_ |
varchar2 |
Nom de la vue logique de la partition Postfix | Default postfix for the name of a partition logical view. | ||
stg_ |
varchar2 |
Préfixe Nom de la vue logique de partition | Default prefix for the name of a partition logical view. | ||
stg_ |
varchar2 |
Mis à jour dans | The code of the function in the modules table from within which the user last updated the record.This value will change for every mutation of the record. | ||
stg_ |
varchar2 |
Mise à jour par | The name of the user in the users table whom last updated the record.This value will change for every update of the record. | ||
stg_ |
varchar2 |
Groupe de système d'origine | Reference for identifying the group of records on the system from which it originated.It is commonly used to group records for later validation in an application control. | ||
stg_ |
varchar2 |
Référence système originale | Référence permettant d'identifier l'enregistrement dans le système d'où il provient. | ||
stg_ |
decimal |
Quelques secondes avant Droppable | Number of seconds after becoming obsolete before a table partition-specific facts table is droppable. | ||
stg_ |
decimal |
À quelques secondes de l'obsolescence | Number of seconds after download before the downloaded data is considered obsolete. | ||
stg_ |
decimal |
Quelques secondes avant la suppression des métadonnées | Number of seconds after the data became obsolete before the metadata is droppable. | ||
stg_ |
decimal |
Durée de conservation (en secondes) des messages entrants transférés | Number of seconds after an incoming messages has been forwarded before becoming eligible for a delete. | ||
stg_ |
varchar2 |
Session Créé | The ID of the session which created the record.This value will not change after insert. | ||
stg_ |
varchar2 |
Session mise à jour | L'identifiant de la session qui a effectué la dernière mise à jour de l'enregistrement. | ||
stg_ |
varchar2 |
Version du moteur SQL | Version of the SQL engine used to update the repository data model. | ||
stg_ |
varchar2 |
Token | Token for authentication to download messages from the Customer Service. | ||
stg_ |
varchar2 |
Transaction créée | The ID of the transaction which created the record. | ||
stg_ |
varchar2 |
Transaction mise à jour | The ID of the transaction which last updated the record. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :