how can i answer for question like teradat architecture in
interveiw
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
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Highlight the differences between Primary Key and Primary Index.
What is dimensional modeling?
Differentiate database data and data warehouse data?
Is multi insert ansi standard?
Can you connect multiload from ab initio?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the term 'database' related to relational database management system?
What are the functions of a teradata dba?
What are the multiload utility limitations?
What is meant by a dispatcher?
Discuss the advantages of using partitioned primary index in a query?
Why managing the data is important?
Syntax for case when statement?
What is the difference between global temporary tables and volatile temporary tables?
Explain how spool space is used.