Differences OLTP vs Data Warehouse in February 2013

Traditional systems of transactions and data warehousing applications are polar opposites in terms of their design requirements and operating characteristics.
OLTP applications are organized to execute transactions for which they were made, for example, move money between accounts, a charge or credit, a return of inventory, etc.. Furthermore, a data warehouse is organized based on concepts such as: customer invoice, products, etc.
Another difference lies in the number of users. Normally, the number of users of a data warehouse is less than one OLTP. It is common to find that transactional systems are accessed by hundreds of users simultaneously, while only tens Data Warehouse. OLTP systems perform hundreds of transactions per second while a single query of a Data Warehouse can take minutes. Another factor is that transactional systems frequently are smaller in size to the data warehouses, this is because a data warehouse information can consist of several OLTP's.
There are also differences in the design, while an extremely normalized OLTP, of a Data Warehouse tends to be denormalized. The OLTP typically consists of a large number of tables, each with few columns, while in a data warehouse is the lower number of tables, but each of them tends to be greater in number of columns.
The OLTP is continuously updated by operational systems every day, while the Data Warehouse are updated periodically batch.
OLTP structures are very stable, rarely change, while those of Data Warehouses derivatives are constantly changing their evolution. This is because the types of queries to which they are subject are varied and it is impossible to foresee all in advance.
Improving Information Delivery: complete, correct, consistent, timely and accessible. Information that people need, in the time you need it and in the format you need.
Improve Decision Making Process: With more support information are obtained faster decisions, and also the business people acquire greater confidence in their own decisions and those of the rest, and achieved a greater understanding of the impacts of their decisions .
Positive Impact on Business Processes: when people are given access to a better quality of information, the company can achieve on its own:
   · Eliminate delays business processes resulting from incorrect, inconsistent and / or nonexistent.
   · Integrate and optimize business processes through sharing and integrated information sources.
   · Eliminate the production and processing of data that is not used or required as a result of poorly designed applications or no longer used.