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
- 2 Answers
- 8978 Views
- Cap Gemini, IBM, Infosys, I also Faced
- E-Mail Answers
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
Explain teradata architecture in detail with a diagram.
What are the uses of client software involved in teradata?
How do you do backup and recovery in teradata?
Explain some differences between mpp and smp?
What is a node in teradata? Explain
What is meant by a Highest Cost Plan?
What are the different table types that are supported by teradata?
Differentiate database data and data warehouse data?
What is teradata? What are some primary characteristics of teradata?
What is teradata?
Explain vproc in teradata?
Define views in teradata with general syntax.
What is the difference between global temporary tables and volatile temporary tables?
What are differences between teradata and ansi session modes in teradata?
How does hashing happens in teradata?
