Answers

Question and Answer:

  Home  General Datawarehousing

⟩ Explain 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.

 160 views

More Questions for you: