Interested to Buy Any Domain ? << Click Here >> for more details...
what is amp plz explanation
- 5 Answers
- 8570 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 5 Yes | 0 No |
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
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is differnce between Error code and Error Level in Bteq
List the logical and conditional operators that are used with teradata along with their meanings?
What is the opening step in basic teradata query script?
Explain fastload in teradata?
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.
What are the primary characteristics of the Teradata.
why should we go Teradata over Oracle,what is the main differences?
How do you set the session mode parameters in bteq?
Why Multiload does not supports USI and supports NUSI?
any one answer me how they can analyzing the project using data ware housing?
What is the Maximum number of volatile tables that can be created?
What are normalization, first normal form, second normal form and third normal form?
Teradata 
