How teradata ensures about any duplicate rows inserted
How teradata ensures that there are no duplicate rows being inserted while this SET table?
Expert
Teradata will redirect the new inserted row according its PI to the target AMP (upon the basis of its row hash (#) value), and when this find same row hash value in which AMP (hash synonyms) then this start comparing the whole row, and determine if duplicate. When it’s a duplicate this silently skips this without throwing any error.
Define the term spanning Tree in data structure?
Define the term filter?
Can we have a report with several data providers?
Provide a brief introduction of the term cubes?
Illustrates the Replication Server in Sybase?
Under what conditions should indexes are employed?
Explain the linked universes?
Define the way of passing of variables to a SQL routine.
Explain and compare OBE and SQL?
Explain about a Cartesian product?
18,76,764
1947875 Asked
3,689
Active Tutors
1414123
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!