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 Data Transformation Manager (DTM)?
What is the corresponding of Oracle/Db2 Coalesce Function within Sybase?
Specify the types of the tracing level?
What is Database testing?
Briefly describe the term Object qualification?
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre
Explain the working of the IPC Stage?
Illustrates the various extensions for stored procedures?
What is meant by the term merge?
What are the Features of Monopoly?
18,76,764
1923511 Asked
3,689
Active Tutors
1454807
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!