Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Data Warehouse Job Interviews:Ab InitioActuateAnalysis ServicesBO DesignerBusiness ObjectsCognos Data WarehouseColdFusionCrystal Enterprise SuiteData IntegrationData ScientistData StageData Warehouse AnalystData Warehouse BIData Warehouse Data MartData Warehouse DeveloperData Warehouse ManagerData Warehouse SupervisorData Warehouses MicroStrategyData WarehousingData Warehousing BasicsDatabase PartitioningEnterprise Data WarehouseETL (Extract, transform, load)General DatawarehousingHyperionImpromptuInformatica Data WarehousingLead Data ScientistMicro StrategyOperational Data StoreReportnetSAS (Statistical Analysis System)Warehouse AssistantWarehouse ConceptsWarehouse DataStageWarehouse Operation ManagerWarehouse Worker
Copyright © 2018. All Rights Reserved
Data Warehouse Developer Interview Question:
Explain me which one is faster, Multidimensional OLAP or Relational OLAP?
Submitted by: Administrator☛ Multidimensional OLAP is faster than Relational OLAP.
☛ MOLAP: Multi-dimensional OLAP
☛ Data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats (one example is PowerOLAP's .olp file). MOLAP products can be compatible with Excel, which can make data interactions easy to learn.
☛ ROLAP: Relational OLAP
☛ ROLAP products access a relational database by using SQL (structured query language), which is the standard language that is used to define and manipulate data in an RDBMS. Subsequent processing may occur in the RDBMS or within a mid-tier server, which accepts requests from clients, translates them into SQL statements, and passes them on to the RDBMS.
Submitted by: Administrator
☛ MOLAP: Multi-dimensional OLAP
☛ Data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats (one example is PowerOLAP's .olp file). MOLAP products can be compatible with Excel, which can make data interactions easy to learn.
☛ ROLAP: Relational OLAP
☛ ROLAP products access a relational database by using SQL (structured query language), which is the standard language that is used to define and manipulate data in an RDBMS. Subsequent processing may occur in the RDBMS or within a mid-tier server, which accepts requests from clients, translates them into SQL statements, and passes them on to the RDBMS.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.