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.