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.
Explain about the Buffer Manager in relational database management system.
Should I use numerous devices to take benefit of Partitions in Sybase?
Define the term Cognos 8 BI?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Homework E-R Modeling Follow a MOVIE database where data is recorded about the movie industry. The data needs are summarized as follows: _ Each and every movie is identified by title & year
Explain the term queue in data structure? Answer: In data structure a queue is a sequential organization of data. It is a first in first out i.e. FIFO type of data s
Describe truncate commands.
Describe the meaning of each of the transaction stages supported by SQL Server?
Explain the way through which we can publish BO report?
Briefly describe the employ of aggregate tables and lookup tables?
18,76,764
1953897 Asked
3,689
Active Tutors
1429334
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!