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…