Critical growing business needs can be a challenge. Meeting these growing demands for more information in a timely manner requires an alternative approach … an approach that accelerates deployments without compromising scalability, reliability, and security. There are many reasons for this data growth and it is important to understand them. More and more parts of an organization are on-line today. Enterprise Resource Planning (ERP), Customer Resource Management (CRM) and other on-line optimizations produce more and more data that is very relevant to an organization. On top of that, new regulatory requirements introduce stricter rules around data retention, typically requiring more data to be kept on-line for longer periods of time. Compliance with various regulatory demands increases the data stored and therefore increases the need to procure more on-line storage capabilities. Rather than just seeing these two trends as a cost center, the most advanced organizations in the world try to turn these resulting large data sets into a competitive advantage. Data Warehouses are traditionally the place where this competitive advantage comes from. Instead of storing the data in OLTP archives, a data warehouse allows analysis of these vast amounts of data by business users. To curb these challenges a data warehouse come into picture. A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but can include data from other sources. Data warehouses separate analysis workload from transaction workload and enable an organization to consolidate data from several sources. Data Warehouse Benefits: Maintaining historical records Analyzing the data to gain a better understanding of the business and to improve the business.