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 Manager Interview Question:
Tell me why is dimensional normalization not required?
Submitted by: AdministratorDimensional normalization allows the database related problems to be solved. It is used to remove the redundant attributes that are used as de-normalized dimensions. Dimensions consist of sub-dimensions that are joined together in one. The dimensional normalization is not used due to the fact that it makes:
☛ Data structure more complex and due to which the performance can be degraded as it requires lots of joining of tables and keep the relations intact.
☛ The space is not utilized properly and use of more space is required.
☛ The query performance suffers when aggregating or retrieving many dimensional values. This requires proper analysis and making of operational reports are necessary.
Submitted by:
☛ Data structure more complex and due to which the performance can be degraded as it requires lots of joining of tables and keep the relations intact.
☛ The space is not utilized properly and use of more space is required.
☛ The query performance suffers when aggregating or retrieving many dimensional values. This requires proper analysis and making of operational reports are necessary.
Submitted by:
Copyright 2007-2025 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.