I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

---

how teradata fetches a row from primary index table?

1 Answers  

---

What is the purpose of joins in teradata and what are the available join types?

0 Answers  

---

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

4 Answers   Teradata,

---

which utitility can use for loading the data from non-teradata to teradata ?

5 Answers   Wipro,

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

0 Answers  

---

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

12 Answers   CTS,

---

What is the difference between fastload and multiload? Which one is faster?

0 Answers  

---

What is the primary index in teradata?

0 Answers  

---

Explain how spool space is used.

0 Answers  

---

what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,

---

what is object level locking ? where do appear this type of locking ?

0 Answers  

---