Explain Vdisk and its communication with physical data store
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Expert
All AMP vproc should have access to an array controller that in turn accesses the physical disks. AMP vprocs are related with one or more ranks or mirrored pairs of data. The sum of total disk space related with an AMP is termed as a vdisk. A vdisk may have up to three ranks. Therefore Vdisk will communicate with physical storage by array controllers.
Elucidate briefly power center repository?
Explain the difference between expression and aggregator?
Illustrates the term data sparsity and how this effect upon aggregation?
Briefly describe the foreign key columns in dimension table and fact table?
What occurs while rows are determined using a FETCH statement?
Illustrate the term indexing. Specify the kinds of the indexing.
Write down brief note on the differentiation between dynamic cache and static cache?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
What are some of the demerits related with conventional file processing systems?
Illustrates the way to save space while inserting rows monotonically?
18,76,764
1959500 Asked
3,689
Active Tutors
1459663
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!