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 |
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
Why do you get spool space errors? How do trouble-shoot them?
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the newly developed features of Teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
which option is used to restart the fastexport script ?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What do high confidence, low confidence and no confidence mean in explain plan?