Interested to Buy Any Domain ? << Click Here >> for more details...
when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 10099 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / saptashaw
Star is better for performance.
Snowflake happens when one or more dimension tables in the
Star are normalized. This is done when there is sparsity in
the concerned dimensions.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are slice and dice?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
How create measures and demensions?
What are the types of folder present in cognos?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What junk dimension contains?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
How do we convert from Numeric to be Words?
What are types of batch available in cognos?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Explain difference between powerplay transformer and power play reports?
-------------What is Coditional Prompting?
What are various types of gateways in cognos?
What are the main services provided by application tier?
