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
- 8979 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
Mention a few of the ETL tools that come under Teradata.
Highlight the differences between Primary Key and Primary Index.
What do you mean by caching in teradata?
In Teradata, what is the significance of UPSERT command?
Highlight a few of the advantages that ETL tools have over Teradata.
Why managing the data is important?
Explain the term 'database' related to relational database management system?
Which is more efficient group by or distinct to find duplicates?
Explain the term 'row' related to relational database management system?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Write a program to show the parser component used in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What are teradata utilities?
What are the design features involved in teradata?
Explain amp in teradata?
