Wednesday, April 11, 2018

Purpose of default Physical schema for a dataserver - Interview Question


Purpose of default Physical schema for a dataserver:

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_.