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 |
any one pls tell me what are the table names in banking project?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
Highlight all the modes that are present under Confidence Level.
What are the different softwares used with their functions in teradata?
Explain the advantages of partitioned primary index in a query?
I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?
why use references rather than pointers in the public api, particularly for arguments which are modified?
which join mostly use in realtime?
What are the different design perspectives used in teradata?
write lock is compatiable with which type of lock?
How many codd's rules are satisfied by teradata database?