Answer Posted / sai

Teradata Architecture is shared nothing architecture(Data
stored in one AMP can not shared with another AMP)
It(TD Architecture) mainly consist of 4 components
PE,BYNET,AMP,vdisks
PE-Parsing Engine -The main function of PE is it handeles
the user session and checks for syntax and gives the
execution plan for all AMPS
BYNET- is banyan n/w it is communication layer b/w PE and
AMP whatever execution plan given by PE is transfered to
all AMPs with the help of BYNET.It also sends answerset to
the PE from the AMPs
AMP-Access Module processor-It is a virtual processor and
it handles some amount of databse space.It also uses
DBsubmanagement system to process query(like
create/manipulation)
vdisk-Virtual disk-Each AMP consist of its own vdisk to
maintain their Data

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

1747

---

Difference between multiload and tpump?

1104

---

How many codd's rules are satisfied by teradata database?

1112

---

Difference between inner join and outer join?

1026

---

What are the components provided on node?

1042

---

What are the different table types supported by teradata?

968

---

What is a node in teradata?

998

---

What is the opening step in basic teradata query script?

1037

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867

---

What are some primary characteristics of teradata?

1000

---

What is the use of virtual processor connectivity in teradata?

1028

---

Mention a few of the ETL tools that come under Teradata.

1079

---

How can bottlenecks be identified?

1018

---

What are the things to be considered while creating secondary index?

1101

---

What interface is used to connect to windows based applications?

1114

---