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 are the joins in teradata and how many types of joins are there in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the uses of client software involved in teradata?
What is meant by a Parsing Engine?
Explain amp in teradata?
How can you track login parameters of users in teradata?
What is a clique?
Highlight the advantages of PPI(Partition Primary Index).
In the Primary Index, what is the score of AMPs that are actively involved?
What is logical data model?
What do you mean by tpt in teradata?
What are the functions of a Parser?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are the advantages of teradata?