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 |
How do you create tables? Exact syntax, and create profiles, users in teradata?
teradata support to automatically increase the character length or not?
What are the steps involved in the process flow of the sql statement through channel attached system?
How to relege locks in fastload and multiload? example?
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?
What are the uses of client software involved in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is difference between user and database in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Explain Teradata performance tuning and optimization?
Explain PDE.
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?