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.
Give a brief introduction of the term analysis service?
Benefits of Computing: Cloud computing has entirely changed the structure and the way of the delivery of IT services to different organizations. With the advent of cloud computing, now the organizations need not have to own the IT infrastructure thems
Describe the main characteristic of the database administrator?
Explain the term Chasm trap?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
Explain and compare OBE and SQL?
Explain the types of views within Data stage Director?
Explain for what the Supervisor module is used?
Describe in brief about the Sybase group?
What is Datadriven?
18,76,764
1936109 Asked
3,689
Active Tutors
1430691
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!