Insertion of duplicate rows-Teradata
Explain how teradata ensures that there are no duplicate rows being inserted when it’s a SET table?
Expert
Teradata will redirect the new inserted row as per its PI to target AMP (on the basis of its row hash value) and if it find out same row hash value.
AMP (hash synonyms) then it begins comparing the entire row and find out if duplicate.
If it’s a duplicate it silently skips it devoid of throwing any error.
How can we do unit testing into the informatica? How to load data in the informatica?
Illustrate stored procedures, and how do they are distinct from triggers?
Explain the automated document scheduling and distribution?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
Explain the way to search for data in a linked list.
Illustrates the term Merge Sort?
MiniSQL Parser Relax; you don't have to write the parser! On the contrary, a complete parser and type checker for the MiniSQL language is provided with the skeleton code. This small subset of SQL includes the
Explain the term Cognos Connection?
When must you seem de-normalization?
Explain the Stored Procedure transformation?
18,76,764
1954010 Asked
3,689
Active Tutors
1431937
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!