Answer Posted / chinna

In Teradata13 Added 93 New Features and While Improves the
performance more tan 30% The query.Teradata Viewpoint
Provides A Suite of Web Based Applications That enable you
to monitor and manage Teradata DataBase system Permance
From Any where using Standard Browser
1.Added NOPI
2.STORAGE LEVEL
3.PORTLETS
4.GEO SPATIAL SUPPORT
5.TERADATA MULTISYSTEM MANAGER
6.MAINLY DESIGNED FOR (a)DATA MART APPLIANCE
(b)EXTREM DATA APPLIANCE
(c)DATA WAREHOUSE APPLIANCE
(d)ENTERPRICE DATAWAREHOUSE
7.NOPI

What are teradata utilities?

1031

---

What is spool space? Why do you get spool space errors?

947

---

How to load specific no.of records using bteq, or fastload,or multiload

1689

---

What are the components used in smp and massively parallel processing (mpp) machines?

999

---

Explain the meaning of Amp?

1031

---

Explain Teradata performance tuning and optimization?

1105

---

Describe the between keyword in teradata?

978

---

Highlight the advantages of PPI(Partition Primary Index).

1004

---

What are normalization, first normal form, second normal form and third normal form?

992

---

What is smp and mpp platforms?

894

---

What are the advantages of teradata?

955

---

What is a sparse index?

1020

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1723

---

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

954

---

Explain fallback in teradata?

983

---