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 comparision 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:


This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-24.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.