Is PK concept available in Teradata. If it is how can we
create Primary Key for a table in TD
Answer Posted / rahul
hi,
primary keys are not mandatory in the teradata,but when
we are specify the pk in column the optimizer creates the
upi in that column. and more over pk composite have no limit
in teradata. the creation of pk is combination of primary
key and not null see the example
create set/multiset table <table name>
(
orderid integer primary key not null,
---
----- etc
);
this creates upi on the orderid column.
if we doesn't mentioned nupi will be created..
thanks
Rahul
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Name the five phases that come under MultiLoad Utility.
What is teradata and why it is used?
What are the 5 phases in a multiload utility?
Explain and compare pros and cons of snow flake schemas?
What is a three-tier data warehouse?
How do you do backup and recovery in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What interface is used to connect to windows based applications?
What are the advantages of teradata?
How to run a query in teradata?
How do you verify a complicated sql?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the use of virtual processor connectivity in teradata?
What are the joins in teradata?