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.
Give brief introduction of the term an OLAP system and OLTP system?
Illustrate the main merits of employing stored procedures?
Explain the following term: a) ROLAP b) MOLAP
Illustrates the term Monopolistic Competition?
Write down the four purposes of the selection of a data type?
How to handle decimal places while importing a flatfile in informatica?
Write down the level of Granularity of a fact table?
Can we stop and start one session in the concurrent batch?
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
Elucidate how many kinds of dimensions are accessible in the Informatica?
18,76,764
1934348 Asked
3,689
Active Tutors
1417148
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!