Incremental Query: How it excludes the data

[rvnth]

Hi there, 

I’m trying to understand how the incremental query handles exclusions. Suppose there were 5 records created yesterday with values for EID, VIN, and FEATURE_NAME. Today, when the incremental query runs, 2 new records are created with the same EID and VIN but different FEATURE_NAME values. Would these be considered new records?

The incremental query identifies new records based on the REC_CREATE_DATE and excludes records where the combination of EID, VIN, and FEATURE_NAME already exists. If the FEATURE_NAME is unique, will it be treated as a new record?

[ParthaSarathy · Accepted solution]

Hi @rvnth ,

Incremental query excludes already executed records based on primary key of the targeting dimension schema.