Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is amp plz explanation

Answers were Sorted based on User's Feedback



what is amp plz explanation..

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

what is amp plz explanation..

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

what is amp plz explanation..

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

what is amp plz explanation..

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 amp plz explanation..

Answer / khaja

Amp is a vproc

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Teradata Interview Questions

What is the multi-insert?

0 Answers  


What is the basic syntax for teradata select statement?

0 Answers  


What is meant by a Clique?

0 Answers  


Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  


Write a program to show the parser component used in teradata?

0 Answers  


What is the command in bteq to check for session settings ?

0 Answers  


What is the maximum number of dml can be coded in a multiload script?

0 Answers  


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


What are tpump utility limitations?

0 Answers  


Differentiate database data and data warehouse data?

0 Answers  


How you will check the version of teradata?

0 Answers  


hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  


Categories