Answer Posted / malathi
Primay key is a constraint used on a table and used to
impose the rule of uniqueness for the application.
Whereas primary index is the way tera data internally
distributes rwos in a table. Primary index can be created
on any column which may mot be a primary key. In teradata
each table should have a primary index (be default first
column in the table is primary indexed).
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Explain amp in teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What are the 5 phases in a multiload utility?
Difference between inner join and outer join?
What do you mean by tpt in teradata?
What is a three-tier data warehouse?
What's the difference between timestamp (0) and timestamp (6)?
How do you determine the number of sessions?
What is the meaning of Caching in Teradata?
Explain PDE.
What are the various indexes in teradata?
How to select first n records in teradata?
What is difference between user and database in teradata?
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 ?
How is MLOAD Client System restarted after execution?