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

Answer Posted / sasty venkatesh

In teradata primary key concept can be satisfied by creating unique primary index and unique secondary index.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the available join types in teradata?

593


What do high confidence, low confidence and no confidence mean in explain plan?

585


What does sleep function does in fast load?

616


Give the sizes of SMALLINT, BYTEINT and INTEGER.

659


Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

1602






What are the steps involved in the process flow of the sql statement through channel attached system?

655


What are the steps to create a data model?

596


how can we analyze the locks ?

1696


What do you mean by fastexport in teradata?

555


How does hashing happens in teradata?

617


In BTEQ, how are the session-mode parameters being set?

652


Discuss the advantages of using partitioned primary index in a query?

526


Explain amp in teradata?

568


Define views in teradata with syntax.

635


What is the syntax for case when statement?

585