Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD

Answer Posted / santhosh

In teradata for storing and retrieving purpose, PE will use
primary index only.. but we are using PK in teradata for creating joins.. soo in Teradata we are using PK and FK..

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why teradata is used?

577


What is upsert statement in teradata?

610


What are the main components of teradata system?

581


What is the difference between teradata and oracle?

555


What is a node in teradata? Explain

601






Can we collect statistics on table level?

601


Explain the term 'foreign key' related to relational database management system?

554


What are tpump utility limitations?

594


What interface is used to connect to windows based applications?

581


What is smp and mpp platforms?

525


What do you mean by ttu in teradata?

569


Highlight a few of the advantages that ETL tools have over Teradata.

610


During the Display time, how is the sequence generated by Teradata?

614


Can we collect statistics on multiple columns?

564


What is primary index and secondary index?

569