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.
I have to prepare an assignment on the topic "SQL Triggers and Procedures". Please help me to complete my assignment.
Illustrates the Delete commands.
Illustrate in brief some of the products of the Sybase?
Describe the differences between an extranet and an intranet.
Name four applications which are employing for triggers in DBMS?
Describe the difference between a regular sub query and a correlated sub query?
Write down the employ of incremental aggregation?
Specify the several types of Strategies?
Illustrates the implementation of business logic within stored procedures?
Describe the three types of data sources which are used with ODBC?
18,76,764
1953614 Asked
3,689
Active Tutors
1456611
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!