| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: Why should you put your data warehouse on a different system than your OLTP system
|
| July 07, 2005 19:13:39 |
#3 |
| Kenneth |
Member Since: Visitor Total Comments: N/A |
RE: Why should you put your data warehouse on a different system than your OLTP system
|
| An DW is typically used most often for intensive querying . Since the primary responsibility of an OLTP system is to faithfully record on going transactions (inserts/updates/deletes), these operations will be considerably slowed down by the heavy querying that the DW is subjected to. |
| |
Back To Question | |
