GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Next Question 
 Basics  |  Question 1 of 113    Print  
What is a Data Warehousing?
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.




  
Total Answers and Comments: 13 Last Update: December 10, 2008   
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: R. Mohanraj
 
A Data warehouse is a subject oriented, integrated, time-variant, nonvolatile collection of data to enable decision making across disparate group of users.

Above answer was rated as good by the following members:
phdsong, maruthi2006msc, mpgupta99, butair
  Sorting Options  
  Page 1 of 2   « First    1    2    >     Last »  
August 16, 2005 01:36:01   #1  
Praveen        

RE: What is a Data Warehousing?
Datawarehosing is a process of creating queriring and populating datawarehouse. it includes a number of discrete technologies like
Identifying sources
Process of ECCD ETL which includes data cleansing data transforming and data loading to targets.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
August 25, 2005 08:03:59   #2  
R. Mohanraj        

RE: What is a Data Warehousing?
A Data warehouse is a subject oriented integrated time-variant nonvolatile collection of data to enable decision making across disparate group of users.
 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
September 14, 2005 05:52:18   #3  
sundeep pattanayak        

RE: What is a Data Warehousing?
A data warehouse is a repository containing subject-oriented integrated time-variant and non-volatile collection of data used for companys decision support systems requirement
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 28, 2005 11:05:45   #4  
Shubhodip Chakravarty        

RE: What is a Data Warehousing?

Datawarehousing is a subject oriented authoritative integrated historical database reflective of changes over meaningful time periods in order to facilitate query and analysis for useful management decision making.


 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
September 28, 2005 11:13:24   #5  
Shubhodip Chakravarty        

RE: What is a Data Warehousing?

Datawarehousing is a subject oriented authoritative integrated historical database reflective of changes over meaningful time periods in order to facilitate query and analysis for useful management decision making.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 03, 2005 23:43:15   #6  
senthil kumar.B        

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.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
January 12, 2006 03:49:03   #7  
sithusithu Member Since: December 2005   Contribution: 161    

RE: What is a Data Warehousing?

Data-Warehouse-Prozess (englisch data warehousing) ist der Prozess zur Bewirtschaftung und Auswertung eines Data-Warehouses der die folgenden Schritte umfasst: #Datenbeschaffung: das hei t die Extraktion der relevanten Daten aus den Quellsystemen Transformation und gegebenenfalls Bereinigung der Daten (Data Cleansing) in einem Arbeitsbereich (englisch staging area) sowie Laden in das Data-Warehouse. Dieser Schritt wird auch Extract-Transform-Load-Prozess (ETL-Prozess) genannt.

Cheers

Sithu


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
August 08, 2006 03:27:51   #8  
sunil        

RE: What is a Data Warehousing?
a subject oriented time varient non volatile and integrated decision supporting system.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
November 29, 2006 02:30:01   #9  
rma        

RE: What is a Data Warehousing?
Data Warehousing is a collection of Subject Oriented Integrated non-Volatile and time Varient to Support Management decision-making Process
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
August 22, 2007 09:05:21   #10  
amarnath.a Member Since: August 2007   Contribution: 2    

RE: What is a Data Warehousing?

A single complete and consistent store of data obtained from a variety of diff sources made available to end users in what they can understand and use in a business context.
As per bill Inman - a collection of subject oriented integrated nonvolatile and time varying data which is used in the process of decision making.
As per Ralph Kimball - a copy of transactional data specially structured to query and analysis.
In layman words - a data warehousing is a read only database which copies and stores the data from transactional data.


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
  Page 1 of 2   « First    1    2    >     Last »  


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape