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

What is called partitioned primary index (ppi)?

1055

---

What are the various indexes in teradata? Why are they preferred?

1054

---

Explain the term 'database' related to relational database management system?

1038

---

Did you write stored procedures in teradata?

1187

---

How to Extract data from multiple legacy systems?

1176

---

Highlight the differences between Primary Key and Primary Index.

1145

---

What is the difference between fastload and multiload? Which one is faster?

1298

---

What is difference between user and database in teradata?

1117

---

How does hashing happens in teradata?

1147

---

What are tpump utility limitations?

1177

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2530

---

How to run a query in teradata?

1146

---

What are the primary characteristics of the Teradata.

1237

---

How can we check the version of Teradata that we are using currently?

1110

---

Highlight the points of differences between the database and user in Teradata.

1169

---