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
- 9111 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 purpose of joins in teradata?
Highlight the advantages of PPI(Partition Primary Index).
How to load specific no.of records using bteq, or fastload,or multiload
What is the purpose of indexes?
What are the frequently used data types in teradata?
What is inner join and outer join?
what are the day to day activities of teradata DBA ?
How would you load a very large file in teradata in general?
How can we check the version of Teradata that we are using currently?
Why is the case expression used in teradata?
What is the use of virtual processor connectivity in teradata?
What is the purpose of using case expression in teradata?
How to identify ppi columns?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is teradata? What are some primary characteristics of teradata?
