IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN
ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES
HOW?PLZ GIVE ME A EXAMPLE.
Answers were Sorted based on User's Feedback
Answer / oceanblue
Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.
e.g.
A Salary Table will have employee ID as primary key. The
table also contains TAX-ID which can not be null or duplicate.
Is This Answer Correct ? | 7 Yes | 0 No |
Why do you get spool space errors? How do trouble-shoot them?
What is the maximum number of dml can be coded in a multiload script?
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
Give some points about Teradata Viewpoint ?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
What are the different functions included in the server software?
What are the different methods ot loading a dimension table? A fact table etc?
What is smp and mpp platforms?
What is the purpose of joins in teradata?
How do you determine the number of sessions?
Can we collect statistics on multiple columns?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?