IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
- 10 Answers
- 14967 Views
- I also Faced
- E-Mail Answers
Answer Posted / maran
No No.. it shouldnt.. One table should have only one PK.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Mention a few of the ETL tools that come under Teradata.
What is the opening step in basic teradata query script?
What are the design features involved in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Explain the term 'row' related to relational database management system?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain BYNET.
What are the different table types supported by teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
How can we check the version of Teradata that we are using currently?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the purpose of upsert command?
How to select first n records in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
