IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Answer Posted / tdguy
There can be more than one primary key in TD. But PI should
always be one and can contain upto 16 columns. Performance
of Teradata is directly linked to PI. Row hash value (32
bit) is calculated from PI using the hashing function. This
hash value along with the uniqueness id (32 bit value)
helps in locating the amp.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to eliminate product joins in a teradata sql query?
What are the different softwares used with their functions in teradata?
What is a dimension table?
Explain Teradata performance tuning and optimization?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is the purpose of using case expression in teradata?
What are the 5 phases in a multiload utility?
Difference between multiload and tpump?
When tpump is used instead of multiload?
What are the joins in teradata and how many types of joins are there in teradata?
How will you solve the problem that occurs during update?
What are the joins in teradata?
List out teradata data types?
Can you connect multiload from ab initio?
Difference between star and snowflake schemas?