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 / ram
Absolutly No. One table can not have more than one PK. But
u can have 2 cols as 1 PK called Composite Primary Key.
| Is This Answer Correct ? | 40 Yes | 0 No |
Post New Answer View All Answers
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?
if collect stats but it show low confidence why?
What is meant by a Clique?
If a Node is busy what are the steps you can take to avoid ?
Comment whether bottleneck is an error or not.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Explain teradata utilities. What is multiload, fast load, tpump?
Explain some differences between mpp and smp?
What are the various indexes in teradata? Why are they preferred?
What is the purpose of joins in teradata and what are the available join types?
What is meant by a Virtual Disk?
What is collect statistics?
What is the command in bteq to check for session settings ?
Why does varchar occupy 2 extra bytes?