_PK tables are used for handling deleted source records when incrementally loading data. There’s no need to keep anything but the latest set of primary keys … we should truncate the _PK table when using SQL Server as the ODX … or potentially let the Storage Management task handle prior _PK loads.
SUBMITTED
Truncate _PK tables before load
+1
+8Hi
this has already been covered in detail in a discussion:
There is also an Idea already:
, probably better to upvote that than dillute the votes.
+1Thanks, mate … idea upvoted 😀
Cheers, Søren
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
