What are the available primary index types?

0 Answers  

---

why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,

---

What are the functions involved in shared information architecture?

0 Answers  

---

Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,

---

How do you Generate Sequence in Teradata?

3 Answers   TCS,

---

---

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

0 Answers  

---

What are the available primary index types in teradata.

0 Answers  

---

what is use of fload loading into set table?

2 Answers   IBM,

---

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

0 Answers  

---

How to load specific no.of records using bteq, or fastload,or multiload

0 Answers   Infosys,

---