Online Analytical Processing (OLAP) is by far the most complex and advanced SQL Server components. Companies are using OLAP more and more as they try to make sense of their tons of accumulated data. OLAP is used in the mysterious field called "data Analysis," The standard database table represents a flat matrix; SQL Server 2000 Analysis Services use the notion of cubes. The data and corresponding objects are multidimensional, having more dimensions than our four-dimensional space-time continuum; the number of dimensions is limited only by your imagination and hardware capabilities. You must install SQL Server Analytical Services. SQL Server 2000 Analysis Services presents the data from these fact and dimension tables as multidimensional cubes that can be analyzed for trends and other information that is important for making informed business decisions.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Check out MOLAP, ROLAP and HOLAP in SQL Server books online for more infomation.What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?This question is generally asked to see how current is your knowledge. Generally there is a section in the beginning of the books online titled "What's New", which has all such information. Of course, reading just that is not enough, you should have tried those things to better answer the questions. Also check out the section titled "Backward Compatibility" in books online which talks about the changes that have taken place in the new version.
Create Date
:
Saturday, May 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be integrated.We can create reports that are multi-dimensional, supported by time-based analysis and ideal for applications with unpredictable, ad hoc query requirments.
OLTP stands for online transaction processing. OLTP databases are fully normalized and are designed to consistently store operational data, one transaction at a time.It performs day-to -day operations and not support historical data
Create Date
:
Friday, March 14, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Would it be sufficient just to Web-enable R/3 Reports? - Performance - Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end - now imagine that occurring even more frequently. Data analysis - BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.
Create Date
:
Tuesday, September 04, 2007
Click here
to improve the Interview Question, Answer and other fields.