how can i answer for question like teradat architecture in
interveiw
- 4 Answers
- 9003 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
How will you solve the problem that occurs during update?
What is a level of granularity of a fact table?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
Highlight the need for Performance Tuning.
Explain teradata utilities?
How many codd's rules are satisfied by teradata database?
Explain and compare pros and cons of start schemas?
Explain some differences between mpp and smp?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain the parallel data extension in teradata?
What are aggregate tables? How do you design them using teradata?
Teradata 
