what is use of PI(primary index) AND SI(secondary index)

2 Answers   Wipro,

---

How do you Generate sequence at the time of Display?

2 Answers   Infosys,

---

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

---

Can you fastexport a field, which is primary key by putting equality on that key?

0 Answers  

---

How do you Generate Sequence in Teradata?

3 Answers   TCS,

---

What is called partitioned primary index (ppi)?

0 Answers  

---

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,

---

How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 Answers  

---

Aborted in Phase 2 data acquistion completed in fastload?

2 Answers  

---

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,

---

What are the available primary index types in teradata.

0 Answers  

---