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

Which is more efficient group by or distinct to find duplicates?

1090

---

How do you determine the number of sessions?

1064

---

What is real time and near real time data warehousing?

1118

---

Did you write stored procedures in teradata?

1134

---

what are the day to day activities of teradata DBA ?

5826

---

What are the advantages of teradata?

1017

---

What do you mean by tpt in teradata?

1021

---

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1262

---

Explain and compare pros and cons of start schemas?

1067

---

Why is the case expression used in teradata?

1078

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2167

---

Highlight the limitations of TPUMP Utility.

1111

---

Comment whether bottleneck is an error or not.

1159

---

Can we collect statistics on multiple columns?

1067

---