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
What are the different functions performed in development phase?
Which is faster fastload or multiload?
What is meant by a Least Cost Plan?
How to select first n records in teradata?
What is logical data model?
What is bteq script in teradata?
How do you define Teradata?
Why is the case expression used in teradata?
What are aggregate tables? How do you design them using teradata?
What is a three-tier data warehouse?
What is meant by a Channel Driver?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the difference between teradata and basic rdbms?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
List out all forms of LOCKS that are available in Teradata.