What is oltp?

0 Answers  

---

How to find duplicates in a table?

0 Answers  

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

0 Answers  

---

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,

---

Did you write stored procedures in teradata?

0 Answers  

---

What is basic teradata query language?

0 Answers  

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

---

Why AMP & PE are called Vprocs?

4 Answers  

---

List out teradata data types?

0 Answers  

---

If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,

---

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

---

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,

---