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
- 7701 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 will you solve the problem that occurs during update?
What are the various indexes in teradata?
Explain the parallel data extension in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
How you will check the version of teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the main components of teradata system?
Discuss the advantages of using partitioned primary index in a query?
What is meant by a Virtual Disk?
What is the difference between teradata and oracle?
List out some of the primary characteristics of teradata.
what is sysdba and sysdbc ? which has high priority ?
Explain amp in teradata?
Which is more efficient group by or distinct to find duplicates?
Describe primary index in teradata?
