Why AMP & PE are called Vprocs?
- 4 Answers
- 15081 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 |
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
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 various indexes in teradata?
Explain teradata architecture?
If a Node is busy what are the steps you can take to avoid ?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
Why managing the data is important?
How is the teradata different from oracle?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
What is the process to restart the multiload if it fails?
Why does varchar occupy 2 extra bytes?
Teradata 
