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
- 7681 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
How is MLOAD Client System restarted after execution?
Explain fallback in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What is difference between user and database in teradata?
What is the maximum number of dml can be coded in a multiload script?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the primary characteristics of the Teradata.
What are the newly developed features of Teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
Highlight a few of the important components of Teradata?
Where is teradata rdbms used?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What does Amp contain and what are all the operations that it performs?
What is teradata and why it is used?
How to identify ppi columns?
