International Journal of Computer Applications
A Data warehouse is an integral part of those enterprises which want to have a clear business insights from customer and operational data. It includes collection of technologies aimed at enabling the knowledge worker (executive, manager and analyst) to make better and faster decisions. It is expected to present the right information in the right place at the right time with the right cost in order to support the right decision. Over the years, the practice of data warehousing proved that the traditional On-Line Transaction Processing (OLTP) systems are not fully appropriate for decision support.