RPT_CM_FACT_CNTL
This table is a single column table, that is used during the Common incremental etl which process the changes occurred in common dimensions. It stores the name of the table that currently is being processed for the changes occurred in PPM. Reading this table the switchable views builds the view to get data from the original PPM table or only the changes made on the PPM table via CDC table. When there is nothing to process, it is populated with a dummy number.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
CDC |
NULLABLE |
CHAR |
Contains the table name that is currently being processed from the subscribed list of PPM tables for change capture. |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.