Why AMP & PE are called Vprocs?
Answers were Sorted based on User's Feedback
Answer / selvaraj
Both AMP and PE are implemented using software and thus the
word Virtual processor. There is no special hardware (like
a special microprocessor) implementation required AMP and
PE to function. This is quite well explained in their
documentation "Introduction to Terdada Warehouse" page 49.
Hope this helps.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / friend
The versatility of the Teradata Database is based on virtual
processors (vprocs)that eliminate dependency on specialized
physical processors. Vprocs are a set
of software processes that run on a node under the Teradata
Parallel Database Extensions (PDE) within the multitasking
environment of the operating
system.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / tdguy
AMPs and PEs are called Vprocs, because they are software
processes and no separate hardware processors. They reside
in the memory of a node.
| Is This Answer Correct ? | 2 Yes | 0 No |
Vprocs:Virtual process
From PE to AMP (This is the network root via MSP(messege
passing layer),The processing data will store in Disks
(These are Physical disks),Each Amp have too many P.disks,
to migrate these P.disks The Bynet Network maintains
Virtual disks.Thses V.disks will responsible for data
migration.
That y we called this process is Virtual Process(VPROCS).
I think it will help u,,,,,
| Is This Answer Correct ? | 0 Yes | 15 No |
If the table does not have duplicates then which utility you can suggest to load the data ?
Explain the types of join supports by teradata?
What are the 5 phases in a multiload utility?
What are the functions of a Parser?
How is MLOAD Client System restarted after execution?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
Where we use PPI in real time??? What is the disadvantages of PPI?
Explain PDE.
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
Highlight the differences between Primary Key and Primary Index.
Can you fastexport a field, which is primary key by putting equality on that key?
How a Referential integrity is handled in Teradata?