Hash collision?
Answers were Sorted based on User's Feedback
Answer / gowthami
getting the same row hash value for the same row(or) two
different primary index values is called hash collision
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / tdguy
TD uses hashing algorithm to create hash values. Hash value
for a given input is always unique. However as per the
information given by TD, it seems that there are
possibilities that two different PI values can end in same
hash value. This is rare and i hope most of the TD guys
would not have faced it. Such a condition is called
collision.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rahul
Hi gowthami,
what you said its correct,but why don't you try different
answer,it is from mr vinay know..
i don't have clear idea about it.please tell me in very clear
| Is This Answer Correct ? | 0 Yes | 1 No |
what happen if a query fail in dispatcher?
Which is faster fastload or multiload?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
if collect stats but it show low confidence why?
What is SQL Assistence?please eample
What is use of compress in terdata?Explain?
Explain fastload in teradata?
What is meant by Teradata Gateway?
Explain and compare pros and cons of snow flake schemas?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.