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 is teradata? What are some primary characteristics of teradata?
Explain the advantages of partitioned primary index in a query?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
When tpump is used instead of multiload?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the multiload utility limitations?
What is the use of virtual processor connectivity in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
Explain teradata vs. Redshift?
What are the different design perspectives used in teradata?
Different phases of multiload?
Explain the term 'columns' related to relational database management system?
What are the different methods ot loading a dimension table? A fact table etc?
What's the difference between timestamp (0) and timestamp (6)?
Give the sizes of SMALLINT, BYTEINT and INTEGER.