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
- 17844 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 meant by a Least Cost Plan?
What are the different methods ot loading a dimension table? A fact table etc?
What is the purpose of upsert command?
When tpump is used instead of multiload?
Highlight a few of the important components of Teradata?
What is the use of stored procedures in teradata?
What is the difference between global temporary tables and volatile temporary tables?
What interface is used to connect to windows based applications?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the enhanced features in teradata v2r5 and v2r6?
How is the teradata different from oracle?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is teradata?
What is called partitioned primary index (ppi)?
