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
Analysis Services Interview Question:
Explain two reasons why feeding data into OLAP system directly from the source operational system is not recommended?
Submitted by: AdministratorBusiness Users needed to build queries that summarized the data and fed management reports. Such queries, were extremely slow because they usually summarize large amounts of data, while sharing the database engine with every day operations,
Reason1
which in turn adversely affected the performance of operational systems.
Reason2
Delay in strategic planning of the enterprise.
The solution was, therefore, to separate the data used for reporting and decision
making from the operational systems. Hence, data warehouses were designed and built to house this kind of data so that it can be used later in the strategic planning of the enterprise.
Submitted by: Administrator
Reason1
which in turn adversely affected the performance of operational systems.
Reason2
Delay in strategic planning of the enterprise.
The solution was, therefore, to separate the data used for reporting and decision
making from the operational systems. Hence, data warehouses were designed and built to house this kind of data so that it can be used later in the strategic planning of the enterprise.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.