CHAPTER 2

A.You are the CEO of a large organization that implemented a data warehouse for internal analysis of corporate data. The operations manager has written you a memo advocating opening the data warehouse to your suppliers and customers. Explain any control issues to this proposal?

B.Explain why the data warehouse needs to be separate from the operational database.

C.The main components of ERP are Online Transaction Processing (OLTP) and Online Analytical (OLAP). How are OLTP and OLAP different? Provide example for each of them.