GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics

 Print  |  
Question:  What is a Data Warehousing?

Answer: Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier and more efficient to run queries over data that originally came from different sources.

Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the requirements for effective on-line analytical processing (OLAP). As a result, data warehouses are designed differently than traditional relational databases.



October 10, 2005 23:43:15 #7
 senthil kumar.B   Member Since: Visitor    Total Comments: N/A 
RE: What is a Data Warehousing?
 
Datawarehouse contains a collection of historic(history of data) ,integrated ,non-volatile  data ,which is used for analysing and developing forecasting reports.
     

 

Back To Question