IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

Answer Posted / tdguy

Hi,
Correction to the answer mentioned above. Only one PK can
be defined for a table-not null,not duplicate. But there
can be 32 secondary indexes. Thanks Santhosh.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you load a very large file in teradata in general? What utility would you use for it? Why?

587


What are the 5 phases in a multiload utility?

600


What is collect statistics?

580


How to run a query in teradata?

574


What do you mean by tpt in teradata?

579






If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1885


What is meant by a Clique?

577


How does hashing happens in teradata?

611


What is TPD?

896


How do you determine the number of sessions?

606


Why are oltp database designs not generally a good idea for a data warehouse?

591


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

363


What is a sparse index?

615


Highlight the points of differences between the database and user in Teradata.

583


Explain fastload in teradata?

590