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
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is a sparse index?
What is a clique?
What is the difference between fastload and multiload?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is logical data model?
what are the uses of fact table and dimension table in banking project?
Explain parsing engine in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What is teradata and why it is used?
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
What are the components provided on node?
How to eliminate product joins in a teradata sql query?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What is the particular designated level at which a LOCK is liable to be applied in Teradata?