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
Explain the term 'row' related to relational database management system?
What is real time and near real time data warehousing?
What is database exceptions in teradata?
What are the different table types supported by teradata?
What are the different softwares used with their functions in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
In BTEQ, how are the session-mode parameters being set?
if collect stats but it show low confidence why?
Explain and compare pros and cons of snow flake schemas?
What are the functions of a teradata dba?
Difference between stored procedure and macro?
How can you track login parameters of users in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the difference between union and union all in teradata?
What are the scenarios in which full table scans occurs?