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

Can you connect multiload from ab initio?

1166

---

What does sleep function does in fast load?

1089

---

any one answer me how they can analyzing the project using data ware housing?

2429

---

What is inner join and outer join?

1063

---

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

1105

---

What is meant by a Channel Driver?

1172

---

what are the day to day activities of teradata DBA ?

5773

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1081

---

When tpump is used instead of multiload?

1063

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1124

---

Explain the teradata primary index mechanics in detail with a diagram.

935

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2158

---

What are differences between teradata and ansi session modes in teradata?

1121

---

Explain and compare pros and cons of start schemas?

1003

---

What is meant by a Highest Cost Plan?

1011

---