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 is the difference between union and union all in teradata?
Difference between multiload and tpump?
How many types of joins are there in teradata?
If RDBMS is halted what will you do ?
What is teradata? What are some primary characteristics of teradata?
Where is teradata rdbms used?
What are the different table types that are supported by teradata?
In BTEQ, how are the session-mode parameters being set?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is meant by a node?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is the difference between global temporary tables and volatile temporary tables?
Explain amp in teradata?
what is object level locking ? where do appear this type of locking ?
What are the commands to make a new table, change a table and remove a table in teradata?