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
- 8304 Views
- Cap Gemini, IBM, Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the different functions performed in development phase?
What are default access rights in teradata?
How to run a query in teradata?
How many types of joins are there in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
How to view every column and the columns contained in indexes in teradata?
What is the difference between teradata and oracle?
What are the functions involved in shared information architecture?
What do high confidence, low confidence and no confidence mean in explain plan?
Difference between inner join and outer join?
Highlight the limitations of TPUMP Utility.
Can we collect statistics on multiple columns?
What is spool space? Why do you get spool space errors?
What is a level of granularity of a fact table?
