A Data Warehouse is a repository of an organization’s electronically stored data and is specifically designed to facilitate reporting and analysis. By definition
“A warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision making process”.
Subject Oriented : Data that gives information about a particular subject instead of about a company’s ongoing operations.
Integrated : Data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole.
Time-variant : All data in the data warehouse is identified with a particular time period.
Non-volatile : Data is stable in a data warehouse. More data is added but data is never removed. This enables management to gain a consistent picture of the business.
A key activity in the Data Warehousing context is what is known as the ETL (Extract Transform Load) process and the Cleansing process. A variety of tools are available in the market for the ETL process from vendors like Informatica, Business Objects, Microsoft etc.
We at Anurakti Solutions can provide you a whole range of Services in the Data Warehousing field.