Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11649 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / prodyot sarkar
A snowflake schema is a variation on the star schema, in which very large dimension tables are normalized into multiple tables. Dimensions with hierarchies can be decomposed into a snowflake structure when you want to avoid joins to big dimension tables when you are using an aggregate of the fact table. For example, if you have brand information that you want to separate out from a product dimension table, you can create a brand snowflake that consists of a single row for each brand and that contains significantly fewer rows than the product dimension table.
Advantages of Using the Snowflake Schema
i)in some cases may improve performance because smaller tables are joined,
ii)is easier to maintain
iii)increases flexibility.
Disadvantages of Using the Snowflake Schema
i)increases the number of tables an end-user must work with
ii)makes the queries much more difficult to create because more tables need to be joined.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the main difference between schema in rdbms and schemas in datawarehouse?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Why facts table is useful in representing the data?
What are the differences between star and snowflake schema?
What is the difference between olap and datawarehosue?
What are the steps to build the datawarehouse?
What are snapshots? What are materialized views & where do we use them?
Define data warehouse?
What is recovering sessions?
Explain why dimenstion tables are denormalized in nature?
I know of using applysimple, but there are other ways too?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Which columns go to the fact table and which columns go the dimension table?
What is a view as it relates to system modeling?
Explain how to get the first 100 rows from the flat file into the target?
