How teradata makes sure that there are no duplicate rows being inserted when its a SET table?

Teradata will redirect the new inserted row as per its PI to the target AMP (on the basis of its row hash value), and if it find same row hash value in that AMP (hash synonyms) then it start comparing the whole row, and find out if duplicate.
If its a duplicate it silently skips it without throwing any error.

Cheers,
Shilpa

Questions by Shilpa.bateja

Showing Answers 1 - 3 of 3 Answers

saurabh.gupta4u

  • Feb 6th, 2009
 

When the target table has UPI then the Row hash of PI column will lead to the AMP and the duplicate row is rejected with an error.

In case of a NUPI defined on a SET table the duplicate row is compared on all columns and if the entire row is dups then it is rejected without an error code > 0.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions