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 Warehousing Basics Interview Question:
Explain Differences between star and snowflake schemas?
Submitted by: Administratorstar schema is a logical structure that can be arranged with fact and dimension tables
in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
Star Schema: can have less number of joins.
Snow flake: can have more number of joins.
Star Schema : has data redundancy, so the query performace is good.
Snow flake: is normalized, so does not has data redundancey. can have perfomance issues.
Submitted by: Administrator
in a star formation.it looks like a star with fact table at the core of the star and the dimension tables along the spikes of the star.the dimension model is therefore called a STAR SCHEMA.
SNOWFLAKING is a method of normalizing the dimension tables in a star schema.
Star Schema: can have less number of joins.
Snow flake: can have more number of joins.
Star Schema : has data redundancy, so the query performace is good.
Snow flake: is normalized, so does not has data redundancey. can have perfomance issues.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.