How do you Generate Sequence in Teradata?

3 Answers   TCS,

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,

---

what are the file sizes in your project?

2 Answers  

---

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,

---

how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,

---

How will you solve the problem that occurs during update?

0 Answers  

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---

Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers  

---

Hash collision?

3 Answers   Satyam,

---

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

0 Answers  

---

Highlight the need for Performance Tuning.

0 Answers  

---