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
- 8829 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 are the various etl tools in the market?
What do you mean by tpt in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the commands to make a new table, change a table and remove a table in teradata?
What are the different table types that are supported by teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is meant by a Highest Cost Plan?
How many types of joins are there in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What is teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Which is faster fastload or multiload?
What are the various indexes in teradata?
What are the joins in teradata?
What are some primary characteristics of teradata?
