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.
Explain the term Enterprise and Workgroup modes?
Can we stop and start one session in the concurrent batch?
Illustrates the implementation of business logic within stored procedures?
Write down the importance for using repository connectivity?
In Sybase illustrates the term Table Partitioning?
Illustrates the third normal form?
Explain the following terms: Proactive, Retroactive and immediate Update.
Give a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?
Define the way of passing of variables to a SQL routine.
Illustrates the TDS protocol in Sybase?
18,76,764
1959809 Asked
3,689
Active Tutors
1451124
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!