How teradata ensures about any duplicate rows inserted
How teradata ensures that there are no duplicate rows being inserted while this SET table?
Expert
Teradata will redirect the new inserted row according its PI to the target AMP (upon the basis of its row hash (#) value), and when this find same row hash value in which AMP (hash synonyms) then this start comparing the whole row, and determine if duplicate. When it’s a duplicate this silently skips this without throwing any error.
Explain some of the ETL Tools?
Explain the drill mode?
Illustrates the uses of C++ in Clipper?
Illustrates the System R and its major subsystems?
Briefly explain the capabilities and concepts of Business Object?
Illustrates the relationship between a queue and underlying array of data structure?
Elucidate how many ways you make ports?
Explain what is database connection?
Write down the security level employed in BO?
Categorize the Hashing Functions based on the different methods through which the key value is found?
18,76,764
1923618 Asked
3,689
Active Tutors
1425055
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!