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.
Briefly describe the differentiation between star and snowflake schemas?
Cloud Computing – A computing capability that provides an abstraction between the computing resource and its underlying technical architecture (e.g., servers, storage, networks), allowing convenient, on-demand network access to a shared pool of
Describe briefly the term data warehouse?
Explain the automated document scheduling and distribution?
Explain what do you mean by the virtual warehouse?
How can I partition any table in Sybase? Explain.
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
What is meant by star schema?
Is the shortest distance between any 2 specified nodes is given by minimum spanning tree?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
18,76,764
1944675 Asked
3,689
Active Tutors
1413217
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!