Interested to Buy Any Domain ? << Click Here >> for more details...
when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 10259 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
Can you define set to be cardinality?
Name the types of gateway?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is meant by Reportstudio shortcut?
how you create security to reports?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Explain the characteristics of cognos?
What are the steps to import the two data sources in framework manager?
What are the other methods working as deployment functionality?
What is the difference between Standard and Metrics folder?
------------- How to identify the Revenue Column in Report?
---------------Describe OLAP Reporting and RDBMS Reporting?
what is requery in cognos?
What are products of cognos?
What errors and types of errors you faced in Cognos ReportNet?
