What is the use of virtual processor connectivity in teradata?

0 Answers  

---

What are the joins in teradata and how many types of joins are there in teradata?

0 Answers  

---

What are the functions of a teradata dba?

0 Answers  

---

Write a program to show the parser component used in teradata?

0 Answers  

---

How do you see a ddl for an existing table?

0 Answers  

---

What is a dimension table?

0 Answers  

---

what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

Comment whether bottleneck is an error or not.

0 Answers  

---

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,

---

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

0 Answers  

---

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,

---