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 a clique?
What are the enhanced features in teradata v2r5 and v2r6?
What are some commonly used bteq scripts?
Explain fallback in teradata?
What is real time and near real time data warehousing?
Explain teradata vs. Redshift?
Describe the set operators in teradata.
Explain teradata architecture in detail with a diagram.
What are some primary characteristics of teradata?
In general, how do you optimze any sql in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Explain amp in teradata?
Explain teradata architecture?
What is the command in bteq to check for session settings ?
What is the purpose of indexes?