Answer / tdguy

Access Module Processor stores and retrieves the
distributed data in parallel. Ideally, the data rows of
each table are distributed evenly across all the AMPs.
Their job is to receive the optimized plan steps, built by
the PE after it completes the optimization, and execute
them.

Answer / rahul

Amp is a virtual process, it performs dml,ddl operations
and also responsible for applying and releasing locks.
amp having some space to perform operations,like storing the
data.
this space can not be shares any other amp in the node.
dats y we call Teradata architecture is shared nothing.

amps are associated with disk,which will invokes controllers
of the disk after completion of its task.


Thanks
Rahul

Answer / yuvaevergreen

AMPS are the components which operate in parallel. PE
dispatches the plan to AMP thru BYNET. Each amp is connected
to vdisk. AMPs also perform functions like sorting of rows.

Answer / vinoth

Adding to the above points,

Rows will be distributed evenly among the AMP's if you specify the Primary Index for a table.

If you able to use the One AMP operation then you will be able to retrieve faster results. If you use all the AMP then it's called as Full table scan and the query results are very slow here.

Answer / khaja

Amp is a vproc

What are some commonly used bteq scripts?

0 Answers  

What is the purpose of using case expression in teradata?

0 Answers  

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

What are the available join types in teradata?

0 Answers  

When tpump is used instead of multiload?

0 Answers  

which join mostly use in realtime?

2 Answers   TCS,

There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

4 Answers   IBM,

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

What happens in a conflict? How do you handle that?

0 Answers  

what is DYNAMIC SQL in TD?

1 Answers   IBM,

Does SDLC changes when you use Teradata instead of Oracle?

2 Answers