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,

---

Difference between stored procedure and macro?

0 Answers  

---

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

0 Answers  

---

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

---

What are the functions of a teradata dba?

0 Answers  

---

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

Highlight the differences between Primary Key and Primary Index.

0 Answers  

---

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,

---

i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 Answers  

---

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

---

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,

---