How teradata ensures about any duplicate rows inserted

Question

How teradata ensures that there are no duplicate rows being inserted while this SET table?

Answer 1

Teradata will redirect the new inserted row according its PI to the target AMP (upon the basis of its row hash (#) value), and when this find same row hash value in which AMP (hash synonyms) then this start comparing the whole row, and determine if duplicate. When it’s a duplicate this silently skips this without throwing any error.