what is amp plz explanation

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Highlight a few of the advantages that ETL tools have over Teradata.

609


In general, how do you optimze any sql in teradata?

545


In the Primary Index, what is the score of AMPs that are actively involved?

573


What are the scenarios in which full table scans occurs?

534


In Teradata, how do we Generate Sequence?

601






What happens when a node suffers a downfall?

667


What is oltp?

566


What is meant by a Least Cost Plan?

618


What are the available primary index types?

716


Describe the between keyword in teradata?

612


What are the various reporting tools in the market?

610


List out some of the primary characteristics of teradata.

553


What is bteq utility in teradata?

569


What is the difference between fastload and multiload?

792


How do you verify a complicated sql?

625