when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 8717 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
How is cognos model organization works?
How to deploy from one server to another server?
Tell me about Dnamic and Static Dashboards?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
-----------With out using DrillThrough how to do Reports?
What is the advantage of using shortcuts?
what are the special features in cognos reportnet?
What is the use of powerplay web viewer in cognos?
Please explain the different stages in creating a report in cognos report net?
Explain what is the difference between native sql and cognos sql?
Can you define cognos impromptu?
Explain difference between powerplay transformer and power play reports?
How can you link a query to a data container manually in Report Studio?
What is the difference between Open Connection command ang Open Session Command?
how you create security to reports?
