What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  

---

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,

---

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

4 Answers   Teradata,

---

What are the different table types that are supported by teradata?

0 Answers  

---

Explain the term 'database' related to relational database management system?

0 Answers  

---

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,

---

What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  

---

Can we collect statistics on multiple columns?

0 Answers  

---

How do you Generate sequence at the time of Display?

2 Answers   Infosys,

---

what are the file sizes in your project?

2 Answers  

---