More DBA job interview questions and answers at
(Continued from previous question...)
Why should you put your data warehouse on a different system than your OLTP system?
A 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 querry is fired on a OLTP system will cause a heavy overhead on the OLTP server that will affect the daytoday business directly.
The loading of a warehouse will likely consume a lot
of machine resources. Additionally, users may create
querries 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.
(Continued on next question...)