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.
What pointer type will you use while using C language to implement the heterogeneous linked list?
Illustrate the difference between the data warehousing and OLAP?
Elucidate briefly power center repository?
Explain Triggers and Rules?
Illustrates the difference between a user’s defined function and a stored procedure?
Write down a short note on Website security issues?
List out the different types of the data providers?
Describe the relationship of OLE DB, ADO, and ODBC?
Explain the way of establishing connection by ODBC.
Describe briefly the term maximum and minimum cardinality?
18,76,764
1954444 Asked
3,689
Active Tutors
1455727
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!