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.
Write a brief note on the differences between a data warehouse and data mart?
Explain the term Relationship in brief.
Describe the term Java bean?
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
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
Name four applications which are employing for triggers in DBMS?
Give a brief introduction of the term non-additive facts?
Give a brief note on the term degenerate dimension table?
Specify the types of dimensions which are available in the Informatica?
What is Datadriven?
Explain the types of jobs we have within the Data stage?
18,76,764
Questions Asked
21,311
Experts
9,67,568
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!