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
- 8269 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 the function of parser component in teradata?
How to eliminate product joins in a teradata sql query?
When tpump is used instead of multiload?
What is spool space? Why do you get spool space errors?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is the use of having index on table?
What is collect statistics?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain and compare pros and cons of start schemas?
What is the purpose of joins in teradata?
What interface is used to connect to windows based applications?
What are the different design perspectives used in teradata?
What is meant by a Virtual Disk?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
