RE: Why should you put your data warehouse on a different system than your OLTP system
OLTP system stands for on-line transaction processing.
These are used to store only daily transactions as the changes have to be made in as few places as possible. OLTP do not have historical data of the organization
Datawarehouse will contain the historical information about the organization
RE: Why should you put your data warehouse on a different system than your OLTP system
Data Warehouse is a part of OLAP (On-Line Analytical Processing). It is the source from which any BI tools fetch data for Analytical reporting or data mining purposes. It generally contains the data through the whole life cycle of the company/product. DWH contains historical integrated denormalized subject oriented data. However on the other hand the OLTP system contains data that is generally limited to last couple of months or a year at most. The nature of data in OLTP is: current volatile and highly normalized. Since both systems are different in nature and functionality we should always keep them in different systems.
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.
