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

What are the components used in smp and massively parallel processing (mpp) machines?

602


Highlight all the modes that are present under Confidence Level.

540


What is primary index and secondary index?

574


What is the purpose of joins in teradata?

546


What are aggregate tables? How do you design them using teradata?

636






When tpump is used instead of multiload?

630


In the Primary Index, what is the score of AMPs that are actively involved?

578


Difference between multiload and tpump?

623


What is the purpose of joins in teradata and what are the available join types?

548


What is the meaning of Caching in Teradata?

695


what are the uses of fact table and dimension table in banking project?

4105


What are the scenarios in which full table scans occurs?

539


What is the command in bteq to check for session settings ?

636


What are default access rights in teradata?

628


Why is the case expression used in teradata?

593