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.
Describes the main data structures used in following areas: RDBMS, Network data model and Hierarchical data model?
Write down the architectural and functional differentiations between Web Intelligence Reports and business objects?
Explain different domain which is there in BO?
Explain the transformations which are used for the variable port?
Contrast a fat and a thin client?
Name the methods that are available in storing sequential files?
What are the Features of Monopoly?
Which efficient data structure is used in RDBMS, for internal storage representation?
Give a brief introduction of the term analysis service?
Give a brief introduction of the term BUS Schema?
18,76,764
1929134 Asked
3,689
Active Tutors
1448755
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!