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.
Explain what is Designer?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
How would the developer describe all variables using referential data types?
Explain the various types of stages?
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Write down the brief note on the differentiations between Normalizer and Normalizer transformation?
What is meant by the Cardinality?What is meant by the Cardinality?
Explain different domain which is there in BO?
Illustrates the third normal form?
Explain the Data Transformation Manager (DTM)?
18,76,764
1926358 Asked
3,689
Active Tutors
1411999
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!