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
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 |
Explain parsing engine in teradata?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
What is upsert statement in teradata?
what is DYNAMIC SQL in TD?
If table have access lock.In the same table write lock is posible or not?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How do you see a ddl for an existing table?
Why AMP & PE are called Vprocs?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are the primary characteristics of the Teradata.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
0 Answers Infosys, Wells Fargo,
Why MLOAD needs Work Tables?