Difference between Teradata V2R5 and Teradata V12 versions?

2 Answers   IBM,

---

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

---

What are the functions of a Parser?

0 Answers  

---

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 Answers  

---

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,

---

---

What is the syntax for case when statement?

0 Answers  

---

How to identify ppi columns?

0 Answers  

---

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,

---

I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,

---

one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,

---

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,

---

Highlight the advantages of PPI(Partition Primary Index).

0 Answers  

---