when can i use the STAR Schema and SNOWFLAKE Scgena
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 is the information present in the cognos configuration file?
What are shortcuts? Where it can be used? What are the advantages?
what is online view?
----------------------What are the User Securities?
What are all the components of Report Studio?
hi my name is siraj i want to know cognos queriy language
---------------Describe OLAP Reporting and RDBMS Reporting?
What is the function of model design accelerator?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the ways to import data into catalog?
What are the types of studio?
how you migrate reports to cognos 8 from previous versions?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What is the difference between static and dynamic conditions?
-------------What is Coditional Prompting?