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
- 9105 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
How to load specific no.of records using bteq, or fastload,or multiload
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is meant by a dispatcher?
what are the uses of fact table and dimension table in banking project?
What are the steps involved after the disk manager passes the request?
Explain the teradata primary index mechanics in detail with a diagram.
Explain vproc in teradata?
Highlight a few of the important components of Teradata?
What is inner join and outer join?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
During the Display time, how is the sequence generated by Teradata?
When tpump is used instead of multiload?
What are the different softwares used with their functions in teradata?
Define views in teradata with syntax.
What is primary index and secondary index?
