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