Faqs on DW - Pg11

Why should you put your data warehouse on a different system than your OLTP system?

Answer1:
AN OLTP system is basically” data oriented” (ER model) and not” Subject oriented “(Dimensional Model) .That is why we design a separate system that will have a subject oriented OLAP system. Moreover if a complex query is fired on a OLTP system will cause a heavy overhead on the OLTP server that will affect the day-to-day business directly.

Answer2:
The loading of a warehouse will likely consume a lot of machine resources. Additionally, users may create queries or reports that are very resource intensive because of the potentially large amount of data available. Such loads and resource needs will conflict with the needs of the OLTP systems for resources and will negatively impact those production systems