Interested to Buy Any Domain ? << Click Here >> for more details...
Why AMP & PE are called Vprocs?
- 4 Answers
- 16724 Views
- I also Faced
- E-Mail Answers
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 |
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?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
What are the components used in smp and massively parallel processing (mpp) machines?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
what are the file sizes in your project?
What are tpump utility limitations?
Explain some differences between mpp and smp?
What happens when a node suffers a downfall?
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 are oltp database designs not generally a good idea for a data warehouse?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
Teradata 
