Answer / Yamini Vishnoi

Teradata supports several types of joins, including:
1. INNER JOIN: Returns only rows where matching values exist in both tables.
2. OUTER JOIN (LEFT, RIGHT, FULL): Includes all rows from one or both tables, even if no match is found.
3. CARTESIAN JOIN (CROSS JOIN): Produces the Cartesian product of two tables by combining every row in the first table with every row in the second table.
4. NATURAL JOIN: Performs an INNER JOIN using the common columns between two tables without explicitly specifying the join condition.

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,

---

wt r before journal& after journel.....in teradata

4 Answers  

---

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

---

Highlight a few of the important components of Teradata?

1 Answers  

---

Difference between multiload and tpump?

1 Answers  

---

Explain the teradata primary index mechanics in detail with a diagram.

1 Answers  

---

Differentiate database data and data warehouse data?

1 Answers  

---

Hash collision?

3 Answers   Satyam,

---

what happen if a query fail in dispatcher?

1 Answers   Cap Gemini,

---

What do high confidence, low confidence and no confidence mean in explain plan?

1 Answers  

---

What are the functions performed by bynet?

1 Answers  

---

What are two examples of an OLTP environment?

4 Answers  

---