Features of SQL Server Analysis Services
Briefly describe the new features of SQL Server 2005 Analysis Services (or SSAS)?
Expert
Unified Dimensional Model : - This model states the entities employed in the business, the business logic employed to metrics, implement and computations. This model is employed by various analytical applications, spreadsheets and so on for verification of the reports data.
Data Source View : - The UML employing the data source view is mapped to a broad array of back end data sources. This facilitates a widespread picture of the business irrespective of the position of data. With the new Data source view designer, an extremely user friendly interface is facilitates for exploring and navigation the data. New aggregation features : - Previous analysis services aggregate features such as COUNT, SUM, DISTINCT and so forth were not appropriate for all business wants. For illustration, financial organizations can’t employ aggregate features such as COUNT or SUM or identifying the first and the last record. New aggregate features such as FIRST CHILD, LAST CHILD, LAST NON-EMPTY and FIRST NON-EMPTY features are established. Querying tools : - A boosted query and browsing tool permits drag and drop dimensions and evaluates to the viewing pane of a cube. MDX queries and data mining extensions (or DMX) can as well be written. The new tool is simpler and automatically alerts for any syntax mistakes.
Give brief introduction of the term ‘Service Broker components’?
Explain Data Page Locking in Sybase.
Illustrates the Radix Sort?
Explain the object qualification?
Illustrate the difference between the data warehousing and OLAP?
Briefly explain the capabilities and concepts of Business Object?
Illustrate briefly the term SQL sub query?
Explain the following term: a) OLAP b) OLTP
Which of the following method does not support sorting (Exchange, Selection, Insertion, Deletion)?
Give brief introduction of the term an OLAP system and OLTP system?
18,76,764
1939105 Asked
3,689
Active Tutors
1432852
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!