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
What are the design features involved in teradata?
What is a dimension table?
What tools would you use for that?
What is real time and near real time data warehousing?
Describe the set operators in teradata.
What is meant by a Clique?
How to identify ppi columns?
What is teradata? What are some primary characteristics of teradata?
What is the primary index in teradata?
Explain parsing engine in teradata?
What are the frequently used data types in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What is spool space? Why do you get spool space errors?
What is the purpose of joins in teradata and what are the available join types?
Give the sizes of SMALLINT, BYTEINT and INTEGER.