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

What are the different methods ot loading a dimension table? A fact table etc?

576


What are differences between teradata and ansi session modes in teradata?

626


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

597


Syntax for case when statement?

609


What are some commonly used bteq scripts?

566






What are the functions of a Parser?

610


What are the joins in teradata?

571


What is spool space?

602


What do you mean by teradata intelliflex?

632


How to view every column and the columns contained in indexes in teradata?

588


What is real time and near real time data warehousing?

677


Highlight the limitations of TPUMP Utility.

606


Which is more efficient group by or distinct to find duplicates?

646


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

1501


What is a node in teradata? Explain

603