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...

IBM QUESTION

As all we know PE takes the SQL Request and it will give
responce for that query. what is the internal process
happening.how it is taking that sql from the system?????

thanks in Advance

Answer Posted / tdguy

When a SQL is submitted, processing starts with PE.PE
checks for syntax, checks for security and handles
sessions. Then it builds a plan. This plan is communicated
to the BYNET. Based on the plan, BYNET signals the
appropriate AMPS. AMPS inturn, retrieve or store the data
in the respective vdisks. Communications between the
components involve acknowledgement and response signals.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991


What is a sparse index?

1084


What is a clique?

1094


What is the difference between fastload and multiload?

1380


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204


What is logical data model?

1204


what are the uses of fact table and dimension table in banking project?

4556


Explain parsing engine in teradata?

1090


Can you fastexport a field, which is primary key by putting equality on that key?

1178


What is teradata and why it is used?

1098


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2202


What are the components provided on node?

1042


How to eliminate product joins in a teradata sql query?

1029


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2419


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1045