IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A
SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

Answers were Sorted based on User's Feedback

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

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

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

A table can't have two primary key.

 Is This Answer Correct ? 23 Yes 1 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

Primary key
============
1. A table should have only one primary key
2. More than one column can consist of a primary key – upto
64 columns
3. Can not be NULL values (missing values)
4. Should be unique values (no duplicate value)

Foreign key
============
1. A table may have zero or more than that upto 32 keys
2. More than one column can consist a primary key – upto 64
columns
3. Can have NULL values
4. Can have duplicate values
5. There should be a corresponding primary key in the
parent table to enforce referential integrity for a foreign
key

 Is This Answer Correct ? 15 Yes 1 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

No No.. it shouldnt.. One table should have only one PK.

 Is This Answer Correct ? 8 Yes 1 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

There can be more than one primary key in TD. But PI should
always be one and can contain upto 16 columns. Performance
bit) is calculated from PI using the hashing function. This
hash value along with the uniqueness id (32 bit value)
helps in locating the amp.

 Is This Answer Correct ? 3 Yes 0 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

Hi,
Correction to the answer mentioned above. Only one PK can
be defined for a table-not null,not duplicate. But there
can be 32 secondary indexes. Thanks Santhosh.

 Is This Answer Correct ? 1 Yes 0 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

please can you tell me Name at least three brands of
Database Management Systems. need it urgently thank you
very much

 Is This Answer Correct ? 0 Yes 0 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

go through rdbms book by rajiv senapati and rajib mall

 Is This Answer Correct ? 1 Yes 1 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

Hi Tdguy, can you please tell me the syntax to create more
than one primary key for a single table.

 Is This Answer Correct ? 0 Yes 0 No

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSW..

Is it possible to have more than one row on the same table

 Is This Answer Correct ? 1 Yes 2 No

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?

What is Join Index in TD and How it works?

which join mostly use in realtime?

Can any one plz provide the teradata interview questions?

How do you eliminate duplicates?

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

what is identity column in TD?