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

How to view every column and the columns contained in indexes in teradata?

979

---

What is the difference between fastload and multiload? Which one is faster?

1140

---

What are the joins in teradata and how many types of joins are there in teradata?

957

---

What is bteq script in teradata?

1076

---

What are the functions performed by bynet?

980

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2038

---

How would you load a very large file in teradata in general?

967

---

Explain the term 'row' related to relational database management system?

886

---

Difference between multiload and tpump?

1038

---

What is meant by a Channel Driver?

1139

---

How do you do backup and recovery in teradata?

960

---

What do you mean by teradata sql assistant?

995

---

What is the use of having index on table?

949

---

Describe the set operators in teradata.

951

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1016

---