ODI - CDC Journalizing Infrastructure

About

When the journals are started, the journalizing infrastructure (if not installed yet) is deployed or updated.

Trigger

_

When the journalizing knowledge module creates triggers, they are installed on the tables in the Data Schema for the Oracle Data Integrator physical schema containing the journalized tables. Journalizing trigger names are prefixed with the prefix defined in the Journalizing Elements Prefixes for the physical schema. The default value for this prefix is T$. The Database-specific programs are installed separately (see the KM documentation for more information).

The journalizing triggers are the only components for journalizing that must be installed, when needed, in the same schema as the journalized data. Before creating triggers on tables belonging to a third-party software package, please check that this operation is not a violation of the software agreement or maintenance contract. Also ensure that installing and running triggers is technically feasible without interfering with the general behavior of the software package.

Common infrastructure tables

A CDC common infrastructure for the data server is installed in the Work Schema for the Oracle Data Integrator physical schema that is flagged as Default for this data server. This common infrastructure contains information about subscribers, consistent sets, etc for all the journalized schemas of this data server. This common infrastructure consists of tables whose names are prefixed with SNP_CDC_.

Journal tables

Journal tables are installed in the Work Schema. The journal table and journalizing view names are prefixed with the prefixes defined in the Journalizing Elements Prefixes for the physical schema. The default value is J$ for journal tables.

Journalizing views

Journalizing views are installed (as the journal tables) in the Work Schema for the Oracle Data Integrator physical schema containing the journalized tables. The journalizing view names are prefixed with the prefixes defined in the Journalizing Elements Prefixes for the physical schema. The default value is JV$ for journalizing views


Powered by ComboStrap