how can i answer for question like teradat architecture in
interveiw

Answers were Sorted based on User's Feedback



how can i answer for question like teradat architecture in interveiw..

Answer / 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

how can i answer for question like teradat architecture in interveiw..

Answer / karthik

In short :

Its a shared nothing architecture.
Extremely known for parallel distribution of data and fast retrieval of the data.
Very good optimizer to choose the best way to fetch the data.

Is This Answer Correct ?    6 Yes 0 No

how can i answer for question like teradat architecture in interveiw..

Answer / yuvaevergreen

TD architecture
APPLN>>>PE>>>BYNET>>>AMPS>>>VDISKS
Parsing Engine can handle upto 120 sessions. dispatches the plan to bynet.
BYNET is a bidirectional network which dispatches the plan to amps, facilitates the communications between amps and PEs.
AMPS are the ones which take care of sorting the answers, locating the data on the vdisks and dispatching the answersets to BYNET. They work independently.one bynet>>>512 nodes.
VDISKS consists of actual data.one vdisk>>>119GB.
PE and AMPS are called virtual processors.

Is This Answer Correct ?    4 Yes 0 No

how can i answer for question like teradat architecture in interveiw..

Answer / tdguy

TD short description - Main components -
PE,BYNET,AMP,VDISKS. PE handles sessions and generates the
plan. Bynet is message passing layer. Amp stores and
distributes the data in parallel. VDisks - Data storage.
These are some important functions of the components of TD.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,


How can bottlenecks be identified?

0 Answers  


can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,


Explain vproc in teradata?

0 Answers  


How to run a query in teradata?

0 Answers  






write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,


in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers   IBM,


What are the updated features of teradata?

0 Answers  


any one pls tell me what are the table names in banking project?

2 Answers  


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


Explain the advantages of partitioned primary index in a query?

0 Answers  


Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,


Categories