GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Analysis services
Next Question 
 Analysis services  |  Question 1 of 14    Print  
What is Data Warehouse

Data Warehouse

Data from different data sources is stored in a relational database for end use analysis

Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.

Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.




  
Total Answers and Comments: 7 Last Update: November 25, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 17, 2005 06:01:58   #1  
Prathiba        

RE: What is Data Warehouse...
datawarehouse is integrated non vilotae timeviarnt and historical re of entrie cororate related data.
 
Is this answer useful? Yes | No
November 23, 2005 08:21:02   #2  
shalini        

Data Warehouse FAQ's
What is difference in DSS and OLTP ?
 
Is this answer useful? Yes | No
December 19, 2005 07:18:47   #3  
DasK        

What is Data Warehouse...

The DSS is (Decision Support System) used for the decision making purposes not for day-2 day issues.by the top level/ sr/middle level managments people in a established company.

but the OLTP SYSTEMS handles the day-day transactions data entries billing etc issues .

The DSS WILL be handled by only a few users especially

top poeple in the corporate ladder hence The number of users who are making use of DSS are less.

but in OLTP(ONLINE TRANSACTION PROCESSING) the number of the users are high since no such kind of decision making is entailed.

regds

DAs.


 
Is this answer useful? Yes | No
January 04, 2006 04:37:20   #4  
sithusithu Member Since: December 2005   Contribution: 161    

RE: What is Data Warehouse...

Subject oriented

Time variant

Historical

Process oriented

Integrated

Sithu


 
Is this answer useful? Yes | No
January 10, 2006 01:34:02   #5  
sithusithu Member Since: December 2005   Contribution: 161    

RE: What is Data Warehouse...

A data warehouse is a database geared towards the business intelligence requirements of an organisation. The data warehouse integrates data from the various operational systems and is typically loaded from these systems at regular intervals. Data warehouses contain historical information that enables analysis of business performance over time

Cheers

Sithu


 
Is this answer useful? Yes | No
January 17, 2006 00:46:18   #6  
mohanraj Member Since: November 2005   Contribution: 1    

RE: What is Data Warehouse...

A process of transforming data into information and making it available to users in a timely enough manner to make a difference.


 
Is this answer useful? Yes | No
November 25, 2008 09:45:25   #7  
jglickma Member Since: November 2008   Contribution: 2    

RE: What is Data Warehouse
Okay there are two camps on this Bill Inmon which is Date and Coddbased database design that has grown into the ODS reporting DSS database and of course Ralph Kimball whose mythology comprises of a star schema and dimension modeling... I could go on and on but basically a data warehouse is a database that is specifically designed for reporting I leave Inmon to the oltp ODS and a true data wareshouse to Ralph Kimball. When I have to interview a data warehouse DBA et al the first question I ask who is Ralph Kimball and can you tellme about the data warehouse toolkit
 
Is this answer useful? Yes | No


 
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