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
- 8861 Views
- Cap Gemini, IBM, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
When a SQL is submitted, processing starts with PE.PE
checks for syntax, checks for security and handles
sessions. Then it builds a plan. This plan is communicated
to the BYNET. Based on the plan, BYNET signals the
appropriate AMPS. AMPS inturn, retrieve or store the data
in the respective vdisks. Communications between the
components involve acknowledgement and response signals.
| Is This Answer Correct ? | 7 Yes | 0 No |
How to run a query in teradata?
Highlight the limitations of TPUMP Utility.
how do you manage the production space. what are the proactive methods you can take ?
What are the functions involved in shared information architecture?
Why do you get spool space errors? How do trouble-shoot them?
What is Difference b/w PI & PPI?how to implement PPI?
Does SDLC changes when you use Teradata instead of Oracle?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
what is use of PI(primary index) AND SI(secondary index)
what are the day to day activities of teradata DBA ?
What are the commands to make a new table, change a table and remove a table in teradata?
Teradata 
