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
How many sessions of MAX is PE capable of handling at a particular time?
What are the different softwares used with their functions in teradata?
What is a level of granularity of a fact table?
In the Primary Index, what is the score of AMPs that are actively involved?
What is basic teradata query language?
List out some of the primary characteristics of teradata.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How is MLOAD Client System restarted after execution?
What is the use of virtual processor connectivity in teradata?
Mention a few of the ETL tools that come under Teradata.
Why teradata is used?
How to view every column and the columns contained in indexes in teradata?
What is smp and mpp platforms?
Explain the term 'tables' related to relational database management system?
What are the available primary index types in teradata.