Explain teradata architecture in detail with a diagram.

0 Answers  

---

What are two examples of an OLTP environment?

4 Answers  

---

Can you load multiple data files for same target table using fastload?

1 Answers  

---

What is real time and near real time data warehousing?

0 Answers  

---

how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,

---

---

What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,

---

If the script is aborted. why it is aborted and how can you identify ?

1 Answers  

---

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

---

What is the use of virtual processor connectivity in teradata?

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,

---

List out teradata data types?

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,

---