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 |
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
what are the file sizes in your project?
Is multi insert ansi standard?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
What is the purpose of indexes?
What exactly do you know about catching in teradata?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
What are the joins in teradata and how many types of joins are there in teradata?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
Explain teradata vs. Redshift?
What are the functions performed by bynet?
Highlight the differences between Primary Key and Primary Index.