5 votes 5 votes Which of the following related to snowflake schema is true? Each dimension is represented by a single dimensional table Maintenance efforts are less Dimension tables are normalized It is not an extension of star schema Others isrodec2017 + – gatecse asked Dec 17, 2017 edited Dec 20, 2017 by pavan singh gatecse 2.7k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
5 votes 5 votes Snowflake schema consists of a fact table surrounded by multiple dimension tables Each dimension is represented by multiple dimension tables . 1 is false Maintenance efforts are more. 2 is false Dimension tables are normalized (usually in 3 NF) . 3 is True (NB: But in star scheme it may not be true always) It is an extension of star schema. 4 is false answer is 3 sh!va answered Jan 10, 2018 sh!va comment Share Follow See 1 comment See all 1 1 comment reply sristicse commented Apr 14, 2020 reply Follow Share IS It in GATE 2021 sylaabus too?, I mean a hidden topic kinda. 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes (C) should be answer snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables. abhishek tiwary answered Dec 21, 2017 abhishek tiwary comment Share Follow See all 0 reply Please log in or register to add a comment.