datawarehousing questions

1. Enterprises have a crucial need for data warehouses. Discuss.
2. Explain the term strategic information. How are they related to business objectives?
3. Discuss the characteristics of strategic information.
4. How does data warehousing address the information crisis in the enterprise?
5. Discuss the evolution of Decision Support Systems. How are they inadequate at providing strategic information to decision makers?
6. Distinguish between operational and decision-support systems.
7. What are the characteristics and requirements to realize business intelligence at the data warehouse?
8. Define a Data Warehouse. How is it an aggregation of technologies?
9. Why were all the past attempts by IT to provide strategic information failures? List three concreate reasons and explain.
10. Describe five differences between operational systems and informational systems.
11. Why are operational systems not suitable for providing strategic information? Explain with reasons.
12. Discuss six important characteristics of the computing environment necessary to provide strategic information in the enterprise.
13. Describe the types of processing that take place in a data warehouse.
14. A data warehouse is not a product, it is an environment. Support or refute this statement.
15. Enumerate four reasons why data warehousing is the only viable means to resolve the information crisis and to provide strategic information.
16. Explain the defining characteristics of the data content of a data warehouse.
17. Write a short note on data marts.
18. Distinguish between data warehouses and data marts.
19. What are the two approaches in designing data warehouses and data marts?
20. Write a short note on the practical approach to data warehouses and data marts.
21. Enumerate the building blocks of a data warehouse.
22. Write a short note on the source data component.
23. Write a short note on the data staging component.
24. Write a short note on the data storage component.
25. Write a short note on the information delivery component.
26. Explain in brief the metadata and management and control component.
27. What is metadata? Explain its role in the data warehouse?
28. Data integration is more important in a data warehouse than an operational system. Explain.
29. Why does every structure in the data warehouse contain the time element?
30. What is data granularity? How is it applicable to the data warehouse?
31. Enumerate five different functions for data transformation.
32. List six different methods for information delivery.
33. Discuss in brief the significant trends in data warehousing in the following areas:
1. Multiple data types
2. Data visualization
3. Parallel processing
4. Query tools
5. Browser tools
6. Data fusion
7. Agent technology
34. Discuss in brief ERP and data warehouse integration.
35. Write a short note on data warehousing and knowledge management.
36. Write a short note on CRM ready data warehousing.
37. What is active data warehousing? Explain in brief.
38. Write a short on the web-enabled data warehouse.