General Datawarehousing Question:
Download Questions PDF

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

Answer:

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.

Download General Datawarehousing Interview Questions And Answers PDF

Previous QuestionNext Question
List down some of the real time data-warehousing tools?What is an ER Diagram?