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 the Stored Procedure transformation?
Illustrates the purposes of a key component in SQL Server Integration Services (SSIS)?
Explain the designer objects?
Elucidate briefly the term metadata reporter?
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
Briefly describes the systems development life cycle.
Describe briefly the term ODBC?
List out the three kinds of business rules and also define each of them?
What are the purposes of using lookups?
Specify the types of dimensions which are available in the Informatica?
18,76,764
1933728 Asked
3,689
Active Tutors
1459207
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!