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.
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|
Answer / rajiv senapati
|Is This Answer Correct ?||2 Yes||0 No|
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
what is object level locking ? where do appear this type of locking ?
what is identity columns in teradata
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Does SDLC changes when you use Teradata instead of Oracle?
if a error occured in FASTLOAD is the fastload job stops?
How do you eliminate duplicates?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
In your project what type of issues and errors you facing in Teradata
what is identity columns in TD?
What is collect State in Teradata ? what it use and how it works??