RE: Discus two reasons why feeding data into OLAP syst...
Business Users needed to build queries that summarized the data and fed management reports. Such queries were extremely slow because they usually summarize large amounts of data while sharing the database engine with every day operations Reason1 which in turn adversely affected the performance of operational systems. Reason2 Delay in strategic planning of the enterprise.
The solution was therefore to separate the data used for reporting and decision making from the operational systems. Hence data warehouses were designed and built to house this kind of data so that it can be used later in the strategic planning of the enterprise.
RE: Discus two reasons why feeding data into OLAP system directly from the source operational system is not recommended
I think the more specific and technical answer would be the noremalized and denormalized form of data that exists in OLTP and OLAP machines. In OLTP machine you want to keep the data normalized because you want the transaction or the machine to be fast. In OLAP machine you want to keep the data denormalized because the of the complex Querying by the DSS tools.
