We have a new community! Please visit support.timextender.com
Follow

Why is a primary key needed on a source-based incremental table?

When using a source-based incremental load strategy, the primary key is used to compare the incoming records in the raw table with the existing records in the valid table. An incoming record that does not exist in the valid table based on the primary key comparison will be inserted as a new record. Existing records in the valid table will be updated with the values of the incoming record in the raw table.

See these KB articles for reference:


 

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.