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.
Differentiate between Multiload and Fastload in terms of Performance?
Explain the term Enterprise and Workgroup modes?
Improvement in Automation: Cloud computing is designed and coded to perform a lot of operations by itself. It has been designed to operate in a completely automated fashion. It enhances the efficiency of the organization.
Specify the 2 modes of data movement in the Informatica Server?
What is meant by the User Objects? Specify some of its restrictions?
Provide a brief introduction of the term ‘Data warehousing ’?
Give brief introduction of the term broad cast agent?
Give a brief introduction of the term dicing and slicing in business objects?
Define the term Cognos 8 BI?
MiniSQL Parser Relax; you don't have to write the parser! On the contrary, a complete parser and type checker for the MiniSQL language is provided with the skeleton code. This small subset of SQL includes the
18,76,764
1941547 Asked
3,689
Active Tutors
1425653
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!