Interested to Buy Any Domain ? << Click Here >> for more details...
Why AMP & PE are called Vprocs?
- 4 Answers
- 16599 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?
How do you Generate Sequence in Teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Why managing the data is important?
Explain teradata utilities. What is multiload, fast load, tpump?
What is TPD?
Explain the new features of teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is the meaning of Caching in Teradata?
What is Difference b/w PI & PPI?how to implement PPI?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
Teradata 
