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 smp and mpp platforms?
How to load specific no.of records using bteq, or fastload,or multiload
How do you design aggregate tables using teradata?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
what is identity columns in teradata
If RDBMS is halted what will you do ?
I want to write one query How to get Matched records and unmatched records in table?
What are the different methods ot loading a dimension table? A fact table etc?
Explain and compare pros and cons of start schemas?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Explain the term 'tables' related to relational database management system?
what is the default character set in teradata,,?