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
- 7712 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
Did you write stored procedures in teradata?
what is sysdba and sysdbc ? which has high priority ?
What are the components provided on node?
Can you connect multiload from ab initio?
What are some commonly used bteq scripts?
List out all forms of LOCKS that are available in Teradata.
Highlight all the modes that are present under Confidence Level.
What is the use of stored procedures in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
What are aggregate tables? How do you design them using teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is called partitioned primary index (ppi)?
What is the purpose of indexes?
What is the opening step in basic teradata query script?
What is teradata? What are some primary characteristics of teradata?
