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 need for Performance Tuning.
What are the different methods ot loading a dimension table? A fact table etc?
What is the difference between fastload and multiload? Which one is faster?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is meant by a node?
Explain the most common data types used in teradata?
Why managing the data is important?
How do you define Teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the meaning of Caching in Teradata?
What is meant by Teradata Gateway?
What are teradata utilities?
What is spool space?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the various indexes in teradata? How to use them? Why are they preferred?