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.
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
Explain the term Job parameters?
Explain, why we use the lookup transformations?
Describe the main characteristic of the database administrator?
What is meant by the Surrogate key?
Explain the various types of stages?
Specify the System variables?
Briefly explain continuous and discrete data in data mining?
Define the term merge stage?
State the term Sybase 365.
18,76,764
1937114 Asked
3,689
Active Tutors
1439633
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!