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
- 9004 Views
- Cap Gemini, IBM, Infosys, I also Faced
- E-Mail Answers
Answer Posted / sridhar
when the user connect to a database he open a session with PE
there after submit a query.
PE take the query and check the syntax,verify it rights for that PE create session.
session is nothing but logical connection b/w user and Application,it verify the authentication and authorization user, if it k it continues the process.
Next PE perform the parser.
query rewrite mechanism
Optimization
Generate
PE dispatch the response to given Request(User).
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is difference between user and database in teradata?
Explain fallback in teradata?
What are the updated features of teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Explain the term 'columns' related to relational database management system?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is a sparse index?
What is bteq utility in teradata?
What are types of partition primary index (ppi) in teradata?
Explain the meaning of Amp?
How to eliminate product joins in a teradata sql query?
Explain amp in teradata?
Highlight a few of the important components of Teradata?
What does Amp contain and what are all the operations that it performs?
What is the purpose of joins in teradata and what are the available join types?
