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.
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 Question | Next Question |
List down some of the real time data-warehousing tools? | What is an ER Diagram? |