Interested to Buy Any Domain ? << Click Here >> for more details...
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
- 10 Answers
- 17440 Views
- I also Faced
- E-Mail Answers
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
What is real time and near real time data warehousing?
What are the advantages of teradata?
What are the main components of teradata system?
What is the basic syntax for teradata select statement?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is bteq utility in teradata?
Discuss the advantages of using partitioned primary index in a query?
What is spool space? Why do you get spool space errors?
What is inner join and outer join?
What are the various indexes in teradata? Why are they preferred?
How is MLOAD Client System restarted after execution?
Explain Teradata performance tuning and optimization?
How can bottlenecks be identified?
In Teradata, what is the significance of UPSERT command?
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
