Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11426 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 partitioning? What are the types of partitioning?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
What is the difference between data warehouse and operational systems?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is ods (operation data source)?
What is data analysis? Where it will be used?
What is Discrete and Continuous data in Data mining world?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what is the metadata extension?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
Describe the differences between a data warehouse and data mart.
What are vaious etl tools in the market?
Explain the differences between normalizer and normalizer transformation?
