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
- 8344 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
What is inner join and outer join?
What are the string manipulation operators and functions associated with teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Which is more efficient group by or distinct to find duplicates?
What is real time and near real time data warehousing?
What are the design features involved in teradata?
During the Display time, how is the sequence generated by Teradata?
What are types of partition primary index (ppi) in teradata?
What is the difference between union and union all in teradata?
Highlight the differences between Primary Key and Primary Index.
Can we collect statistics on multiple columns?
How do you set the session mode parameters in bteq?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain Teradata performance tuning and optimization?
Describe the set operators in teradata.
