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.
State the types of users in the Business Objects?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Specify the options in the target session of the update strategy transformation?
Briefly describe the ETL procedure in data warehousing?
Explain the various types of stages?
Explain the term Relationship in brief.
What is meant by the term merge?
What is the archtetype or instance pattern?
What is Redundant Array of Inexpensive Disks controller technology?
Why we use Context? And explain the LOV?
18,76,764
1943474 Asked
3,689
Active Tutors
1447907
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!