dc_settings: Data Cache Settings
read only
- Catálogo:
Cache - Esquema:
Invantive - Llaves Primarias:
stg_id - Label: Settings
Central configuration of the software consisting of settings and defaults for configuration of other objects such as tables.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla dc_settings. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
stg_ |
varchar2 |
Permitir actualización automática | 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 |
Actualización automática una vez | 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 |
Creado en | 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 |
Creado por | Quién creo el registro. | ||
stg_ |
datetime |
Creado en | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
stg_ |
datetime |
Actualizado en | 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 |
Identificador de entorno | Unique environment ID. | ||
stg_id |
decimal |
ID | Unique identifier. | ||
stg_ |
char |
Tablas de datos del índice | Default whether indexes on facts tables must be created and maintained. | ||
stg_ |
char |
Tablas de historial de índices | Default whether indexes on history tables must be created and maintained. | ||
stg_ |
char |
Mantener vistas lógicas generales | Default whether overall logical views must be created and maintained. | ||
stg_ |
varchar2 |
Nombre de vista lógica general de Postfix | Default postfix for the name of the overall logical view. | ||
stg_ |
varchar2 |
Nombre de vista lógica general del prefijo | Default prefix for the name of the overall logical view. | ||
stg_ |
char |
Mantener las vistas lógicas de las particiones | Default whether partition logical views must be created and maintained. | ||
stg_ |
varchar2 |
Nombre de vista lógica de partición Postfix | Default postfix for the name of a partition logical view. | ||
stg_ |
varchar2 |
Nombre de vista lógica de partición de prefijo | Default prefix for the name of a partition logical view. | ||
stg_ |
varchar2 |
Actualizado en | 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 |
Actualizado por | 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 |
Grupo del Sistema Original | 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 |
Referencia del Sistema Original | Referencia para identificar el registro en el sistema del que se originó. | ||
stg_ |
decimal |
Segundos antes de Droppable | Number of seconds after becoming obsolete before a table partition-specific facts table is droppable. | ||
stg_ |
decimal |
Segundos antes de quedar obsoleto | Number of seconds after download before the downloaded data is considered obsolete. | ||
stg_ |
decimal |
Segundos antes de que los metadatos se puedan eliminar | Number of seconds after the data became obsolete before the metadata is droppable. | ||
stg_ |
decimal |
Retención de segundos de mensajes entrantes reenviados | Number of seconds after an incoming messages has been forwarded before becoming eligible for a delete. | ||
stg_ |
varchar2 |
Sesión Creada | The ID of the session which created the record.This value will not change after insert. | ||
stg_ |
varchar2 |
Sesión Actualizada | La identificación de la sesión que actualizó el registro por última vez. | ||
stg_ |
varchar2 |
Versión de SQL Engine | 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 |
Transacción Creada | The ID of the transaction which created the record. | ||
stg_ |
varchar2 |
Transacción Actualizada | The ID of the transaction which last updated the record. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: