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.
Briefly explain the Dashboard in the business intelligence?
Explain three types of SQL database server architecture?
Explain middleware applications which ease the connection of databases to Web applications?
Explain the way to support Row Level Locking in Sybase.
Explain the way of transactions in Sybase. How it relates with partition assignment.
What is meant by the parameter file?
How to handle decimal places while importing a flatfile in informatica?
Explain the standard folders?
Write down security domain in Business Objects?
Elucidate how many kinds of dimensions are accessible in the Informatica?
18,76,764
1955532 Asked
3,689
Active Tutors
1418203
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!