Primary Extract Mappings (SDE_*_Primary)

The Primary Extract mappings (SDE_*_Primary) perform a full extraction of only the primary key (INTEGRATION_ID) values from the source system.

The extracted keys are loaded into the corresponding Primary Extract (_PE) staging table (for example, W_REVENUE_F_PE).

The _PE tables represent the complete set of primary keys currently available in the source system and serve as the baseline for identifying deleted records.