Answer / shaik mahamad rafi

One cylinder split data blocks in the clique level the data blocks moved by using bynet and PDE it will going to another cylinder

how teradata fetches a row from primary index table?

1 Answers  

---

What is the difference between SI and JI?

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,

---

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---

During the Display time, how is the sequence generated by Teradata?

0 Answers  

---

Where is teradata rdbms used?

0 Answers  

---

What are the different table types supported by teradata?

0 Answers  

---

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 Answers  

---

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

---

How to run the Teradata jobs in unix environment ???

4 Answers   IBM,

---

what is the difference between start schma and Fsldm?

5 Answers   Intel,

---

What is the purpose of indexes?

0 Answers  

---