What is the purpose of joins in teradata and what are the available join types?

0 Answers  

---

Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load

4 Answers  

---

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

2 Answers  

---

how teradata fetches a row from primary index table?

1 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,

---

What is meant by a Virtual Disk?

0 Answers  

---

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

1 Answers   Satyam,

---

How does hashing happens in teradata?

0 Answers  

---

any one pls tell me what are the table names in banking project?

2 Answers  

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  

---

What is the difference between SI and JI?

2 Answers  

---

What are two examples of an OLTP environment?

4 Answers  

---