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 is the purpose of joins in teradata and what are the available join types?
what is use of fload loading into set table?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
Explain the term 'primary key' related to relational database management system?
What are the steps to create a data model?
why varchar takes 2 extra bytes?
Why Multiload does not supports USI and supports NUSI?
In Teradata, how do we Generate Sequence?
can i call router is a passive transformation
I want to write one query How to get Matched records and unmatched records in table?
1.what is activity count? 2.what is skew factor? how it's working explain brefily
Explain fastload in teradata?