Teradata Question: Download Questions PDF
How teradata makes sure that there are no duplicate rows being inserted when its a SET table?
![Teradata Interview Answer Teradata Interview Question](https://globalguideline.com/public/images/interview/15.png)
Answer:
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.
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.
Download Teradata Interview Questions And Answers
PDF
Previous Question | Next Question |
How many codd,s rules are satisfied by teradata database? | What is the difference between Global temporary tables and Volatile temporary tables? |