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 the term Coalesce. Answer: Coalesce is also obtainable in Sybase, this function estimates the listed expressions and returns the first non-null value.
Write a brief note on a distributed database?
States the term Global temporary.
How you can detect the loops?
Explain the Combined Query?
Elucidate what are the tasks which Load manger process will do?
Describe briefly Recovering sessions?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Why do not you utilize GNU SCONS or autoconf for building?
Illustrates the term explain and how does this work?
18,76,764
1947228 Asked
3,689
Active Tutors
1432438
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!