ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Explain fundamentals of Data ware housing & OLAP?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Explain fundamentals of Data ware housing & OLAP?
Answer
# 1
OLAP 
>Online Analytical Processing (OLAP) is a popular and 
powerful data analytical method.
>It explores the complex data structure and presents the 
information 
OLAP functionality is:
•	Multidimensional -- OLAP services provide a wide 
variety of possible views or a multidimensional conceptual 
view of the data by supporting a dimensional aggregation 
path or hierarchies and/or multiple hierarchies. 
•	Easy to understand -- The data mart designed for 
OLAP analysis should handle any business logic and 
statistical analysis that is relevant to the application 
and the developer, while at the same time, keeps it easy 
enough for the target user. 
•	Interactive -- OLAP helps the user combine business 
information through comparative,. The users are allowed to 
define new ad hoc calculations as part of the analysis and 
can report on the data in any desired way. 
•	Fast -- OLAP services are usually implemented in a 
multi-user client/server mode and offer consistently rapid 
responses to queries, regardless of database size and 
complexity. 
 
Is This Answer Correct ?    3 Yes 1 No
Kamal
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is referential integrity? What are the advantages of it? Digital-Domain3
What is referential integrity and how is it achieved? Adea-Solutions1
Where do you think the users names and passwords will be stored in sql server?  3
what is the main difference between constraints(like primary key etc..)& joins? Annik2
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
select empid empname from employee What is the result for the about query?  4
What is WITH CHECK OPTION Karur-Vysya-Bank-KVB2
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?  2
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000  3
How many index keys possible for a table  6
What is difference beteen Migration and Upgrdation? Satyam4
What value could be assigned to Varchar Type?  3
What is the use of DBCC commands?  1
Can you explain the types of Joins that we can have with Sql Server?  2
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that TCS5
event classes in sql server Accenture1
which database is best to use in oracle and sql server? explain reasons? TCS5
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.  5
how to know description of a table in sqlserver 2000  7
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com Symphony21
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com