Analysis services Interview Questions
What are the key things for ba from requirement definition ?
How do you determine that a use case is needed
Discuss the problems of using semaphores in a distributed system
Data warehouse data from different data sources is stored in a relational database for end use analysisdata 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...
DWh is (6 important points about DWH) :
1. Dedicated Data Base
2. Integrated Data
3. Subject Oriented
4. Time Variant
5. Nonvolatile
6. Decision Support
Idan Halfon
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 st...
Re-engineering of organization
What is re-engineering of an organization?
Reengineering is a fundamental rethinking and radical redesign of business processes to achieve dramatic improvements in cost, quality, speed, and service, this is the same process while Re-engineering an Organization.
Idan Halfon
The UC is more technical analysis, the business requirement document is a word document which includes business analysis
A requirements document defines the business needs for a project. A Use Case Document defines the behavior of a system given a set of user interactions.
What are the main important differences between olap and oltp
OLAP is mostly a BI tool while OLTP is an operation system issue.
Idan Halfon
olap:online analytical processing is that which describes procesing at warehouses.oltp:online transactional processing is that which describes at the operational sites..oltp &nb...
Which are the olap tools available that are supported by Oracle?
Supported by Oracle not owned well Cognos, Microstrategies, Business Objects and they have Hyperion Essbase 9 & 11, plus Oracle reports, Discover plus... their new version is packaged as a BI suite I ...
Hyperion essbase and interactive reporting are OLAP tool
I noticed 3 things going wrong in this portal1. the answers seen are the same as of the first (example: security level tracking for the atm).2. people drop there answers and really speaking if some picks the same answers and deliver it to the others it really creates a great impact on his carrier so...
Rupbuildsdlcplatformagileinception phaseused casetest caserealeasesystemactordeployementimplementationrec prowhite boxjad session
If you switch to code view while building your package object you can modify the MDX and add the non empty reserve word/function.
How can you evaluate a software? Give details of the various approaches of software evaluation? While considering the acquisition of a propriety software package, which technical characteristics must be taken in to account?
I think the more specific and technical answer would be the noremalized and denormalized form of data that exists in OLTP and OLAP machines. In OLTP machine you want to keep the data normalized becaus...
Moreover BI tools need historical data also which is not present in OLTP sysms
What is the difference between analysis and synthesis?
Use MDX
IMRAN
Reporting services allows the slicing and dicing functionality. to see the non empty records, i think you have to create a calculated measure,to hide all the non empty rows.
What is the service name for Microsoft SQL server analysis services 2000?
Mssqlserverolapservice
SQL Server Analysis Service
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
Interview Question
Latest Questions
Ads
Interview & Career Tips
Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.
NH
