Incremental Query: How it excludes the data | Community
Skip to main content
R
rvnth
Level 5
January 8, 2025
Solved

Incremental Query: How it excludes the data

  • January 8, 2025
  • 1 reply
  • 455 views

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @rvnth ,

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

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
January 8, 2025

Hi @rvnth ,

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

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...