ODI - CDC Journalizing Infrastructure

Card Puncher Data Processing

About

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

Trigger

Odi Work Schema

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





Discover More
Odi Jkm Oracle
ODI - Setting up Journalizing/CDC

This is the basic process for setting up CDC on an Oracle Data Integrator data model. Each of these steps is described in more detail below. Set the CDC parameters Add the datastores to the CDC ...
Odi Designer Execute On
ODI - Staging Area (or Work area)

ODI Knowledge Modules often use temporary objects to: stage temporary data for jobs optimization. execute some rules ... These temporary objects are always stored in a particular schema or directory...



Share this page:
Follow us:
Task Runner