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 designer objects?
Why use references quite than pointers within the public API, mainly for arguments that are modified?
Illustrates the purposes of a key component in SQL Server Integration Services (SSIS)?
Write down a short note on the difference between partial specialization and total specialization.
Describe the some drawbacks of a standard language like SQL?
Explain the Data Transformation Manager (DTM)?
Give us a non-computer illustration of preemptive and also non-preemptive scheduling?
Illustrate stored procedures, and how do they are distinct from triggers?
What accurately is SQL Server 2005 Service Broker?
Categorize the Hashing Functions based on the different methods through which the key value is found?
18,76,764
1922423 Asked
3,689
Active Tutors
1428764
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!