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.