07-21-2011, 01:58 PM
1- define parallelism explain it with examplr, under what conditon an operation can be executed in parallel.
2- what is value validation process?
3- Explain analytic application specificaion phase of analytic application track of Kimball's Model?
4- how gender guide is used if large number of records, gender is missing?
5- how page dimensions is useful to check the static and dynamic nature of the web pages.
6- Give name of activities to be performed in planning and desighn phase as discussed in agri-DWH case study
7- Write down the steps which are performed in clustering process.
8- a person wants to visit and understand the data warehouse implementation strategies adopted in that organization but organization refuse to allow what may be the cause of that refusel.
9- what are the three methods of creating a DTS package
10- write the following bit vector in compressed form using run length encoding with # being the separator
11001010110000101000001001010010000001
11- Given the quality blocks STUDENT table are 100 and qualifying blocks for FEE table are 300 STUDENT table has 5000 blocks abd FEE table has 7000 blocks what wwill be the join cost if STUDENT table is outer table.
12- what issue can arise if data is moved dirctly into the data warehouse withour being passed through ETL steps.
2- what is value validation process?
3- Explain analytic application specificaion phase of analytic application track of Kimball's Model?
4- how gender guide is used if large number of records, gender is missing?
5- how page dimensions is useful to check the static and dynamic nature of the web pages.
6- Give name of activities to be performed in planning and desighn phase as discussed in agri-DWH case study
7- Write down the steps which are performed in clustering process.
8- a person wants to visit and understand the data warehouse implementation strategies adopted in that organization but organization refuse to allow what may be the cause of that refusel.
9- what are the three methods of creating a DTS package
10- write the following bit vector in compressed form using run length encoding with # being the separator
11001010110000101000001001010010000001
11- Given the quality blocks STUDENT table are 100 and qualifying blocks for FEE table are 300 STUDENT table has 5000 blocks abd FEE table has 7000 blocks what wwill be the join cost if STUDENT table is outer table.
12- what issue can arise if data is moved dirctly into the data warehouse withour being passed through ETL steps.