what is amp plz explanation
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 |
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Explain the teradata primary index mechanics in detail with a diagram.
What are the primary characteristics of the Teradata.
How many codd's rules are satisfied by teradata database?
What is the syntax for case when statement?
what is the difference between start schma and Fsldm?
What do you mean by tpt in teradata?
What is primary index and secondary index?
What are the various etl tools in the market?
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??
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
If table have access lock.In the same table write lock is posible or not?