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 is meant by the Data Mining?
Explain Triggers and Rules?
List out the different types of the data providers?
Explain the ways to controlling Cursor Behavior.
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Give a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?
In Sybase illustrates the term Table Partitioning?
What do you understand by the termed dependency graph in DBMS?
Give details why an information gap exists in most organizations?
What can be done with the Data Stage Director?
18,76,764
1950433 Asked
3,689
Active Tutors
1445247
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!