DATA_SOURCE_CDC_STAMP
This table stores CDC field values of source tables in the last ETL batch. This table is under the schema that contains management tables.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
Field Name |
Null? |
Field Type |
Description |
---|---|---|---|
SOURCE_CDC_STAMP_ID |
Not null |
INT |
Generated primary key |
SOURCE_INSTANCE_ID |
Not null |
INT |
Unique source instance ID |
SOURCE_INSTANCE_NAME |
Nullable |
Varchar(100) |
Source instance name |
ENTITY_NAME |
Not null |
VARCHAR(100) |
Entity name |
LAST_EXTRACTION_VALUE |
Nullable |
VARCHAR(200) |
CDC field value in the last ETL batch |
MD_CREATETIME |
Nullable |
datetime |
Date when the record is updated |
MD_LASTMODDDATE |
Nullable |
datetime |
Date when the record is updated |
Projections
This table uses no projections.
Sequences
This table uses no sequences.