Hash collision?

Answers were Sorted based on User's Feedback



Hash collision?..

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

Hash collision?..

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

Hash collision?..

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

Post New Answer

More Teradata Interview Questions

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  


what are the file sizes in your project?

2 Answers  


Is multi insert ansi standard?

0 Answers  


How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 Answers  


What is the purpose of indexes?

0 Answers  






What exactly do you know about catching in teradata?

0 Answers  


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?

5 Answers   HCL,


What are the joins in teradata and how many types of joins are there in teradata?

0 Answers  


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

2 Answers  


Explain teradata vs. Redshift?

0 Answers  


What are the functions performed by bynet?

0 Answers  


Highlight the differences between Primary Key and Primary Index.

0 Answers  


Categories