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
- 18085 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
How can bottlenecks be identified?
How many codd's rules are satisfied by teradata database?
Why is the case expression used in teradata?
What is the meaning of Caching in Teradata?
What do you mean by teradata sql assistant?
what is sysdba and sysdbc ? which has high priority ?
Different phases of multiload?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the main components of teradata system?
Difference between stored procedure and macro?
Explain teradata vs. Redshift?
How is MLOAD Client System restarted after execution?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is logical data model?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
