Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD
Answer Posted / tdguy
PK is a logical concept and not mandatory in TD. But PI is
mandatory as the distribution of data is completely
dependent on PI. Choice of PI is very important and can
contain upto 16 columns.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What does sleep function does in fast load?
What are the joins in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain the most common data types used in teradata?
What is a dimension table?
Where is teradata rdbms used?
What are the uses of bynets in multi-node systems?
what are the uses of fact table and dimension table in banking project?
What are the main components of teradata system?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is spool space? Why do you get spool space errors?
Explain the new features of teradata?
What is multi insert?
What are the different table types that are supported by teradata?
What are the functions of a Parser?