Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11630 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 drill-through?
Who needs data warehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Which columns go to the fact table and which columns go the dimension table?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain clustering algorithm?
Explain a linked cube?
What are target types on the server?
Explain ddl (data definition language)?
Explain about core dimension,
How to stop a batch?
What are the different types of join operations?
Explain why denormalization is promoted in universe designing?
Difference between PowerPlay transformer and power play reports?
What is the difference between star and snowflake schemas?
