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 binary relationship set and terenary relationship set
Database Requirements Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: • Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classifie
Specify the different Multidimensional analysis methods which are available in the Business Objects?
Explain the Hash file and the Sequential File?
Explain the term Cognos Connection?
What are the disadvantages in File Processing System?
Core Competency: Helps the managers to think towards developing the core competencies with the help of cloud computing. Huge benefits can be reaped out of the cloud computing.
Illustrates the applications of ASA?
Define the class?
Specify the other areas for the purpose of Data warehousing and the data mining.
18,76,764
1943116 Asked
3,689
Active Tutors
1420639
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!