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
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
what is sysdba and sysdbc ? which has high priority ?
What happens when a node suffers a downfall?
What is meant by a Virtual Disk?
Difference between star and snowflake schemas?
List out teradata data types?
What are the components provided on node?
What is the use of teradata system software?
Explain amp in teradata?
Explain BYNET.
What is primary index and secondary index?
What is the opening step in basic teradata query script?
What is a sparse index?
What is meant by a node?
What is spool space?