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
- 8307 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
Describe the set operators in teradata.
Explain the meaning of Amp?
Highlight the differences between Primary Key and Primary Index.
Syntax for case when statement?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Can you fastexport a field, which is primary key by putting equality on that key?
Difference between star and snowflake schemas?
Steps to create a data model?
What is the purpose of upsert command?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is basic teradata query language?
Highlight the points of differences between the database and user in Teradata.
What is a level of granularity of a fact table?
Write a program to show the parser component used in teradata?
