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.
Illustrates the term Merge Sort?
Specify the tasks of universe designer?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Write a short note on the difference between a dynamic and materialized view?
Explain how in a relation a supertype or subtype is mapped?
What accurately is SQL Server 2005 Service Broker?
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
Give brief introduction of the term an OLAP system and OLTP system?
Why not the PHENIX, the Zelinka or Otwinoski libraries and so forth?
What is Enterprise Resource Planning (or ERP), and what type of a database is employed in an ERP application?
18,76,764
1929702 Asked
3,689
Active Tutors
1439611
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!