How teradata ensures about any duplicate rows inserted
How teradata ensures that there are no duplicate rows being inserted while this SET table?
Expert
Teradata will redirect the new inserted row according its PI to the target AMP (upon the basis of its row hash (#) value), and when this find same row hash value in which AMP (hash synonyms) then this start comparing the whole row, and determine if duplicate. When it’s a duplicate this silently skips this without throwing any error.
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
Provide a brief introduction on the term ‘cube grouping’?
Is it possible that two tasks be assigned to the similar Partition in Sybase?
Explain what is meant by the WebI or Web Intelligence?
Explain the hot backup in case of Oracle.
Write out the disadvantages of using the Alias?
Explain the way to shrink a Database?
Describe how operation is carried out within the spiral method?
What is Database testing?
Illustrates the uses of C++ in Clipper?
18,76,764
1940349 Asked
3,689
Active Tutors
1421528
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!