How teradata makes sure that there are no duplicate rows being inserted when its a SET table?
Submitted by: AdministratorTeradata 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Teradata Job Interview Questions And Answers
Top Teradata Questions
| ☺ | What is stored procedure in Teradata? |
| ☺ | What is the difference between start schma and Fsldm? |
| ☺ | What are the enhanced features in Teradata V2R5 and V2R6? |
| ☺ | How teradata makes sure that there are no duplicate rows being inserted when its a SET table? |
| ☺ | What is an optimization and performance tuning and how does it really work in practical projects? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
