Insertion of duplicate rows-Teradata
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
Expert
Teradata will redirect the new inserted row as per its PI to target AMP (on the basis of its row hash value) and if it find out same row hash value.
AMP (hash synonyms) then it begins comparing the entire row and find out if duplicate.
If it’s a duplicate it silently skips it devoid of throwing any error.
What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?
Explain about the stored-procedures and its advantages.
States the term SnowFlake.
Explain the calculation contexts?
What are the disadvantages in File Processing System?
Give a brief introduction of the term Dimensional Modeling?
Write about the term Attribute, Entity and Relationship?
Give a brief introduction of the term non-additive facts?
What do you understand by the term denormalization and why would someone consider doing so?
How are metadata keys and surrogate handled in MySQL?
18,76,764
1924739 Asked
3,689
Active Tutors
1418673
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!