when can i use the STAR Schema and SNOWFLAKE Scgena

Answer Posted / khushbu

snowflake is normalized model there for it require less storage space.
but star schema is not normalized. it has redundant data therefore require more storage.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How is possible this scenario using in type-in prompt.?

590


What is the difference between a cascading report and drill through report?

650


Can you define cognos impromptu?

624


How do we convert from Numeric to be Words?

2504


What is the difference between a data mart and a data warehouse?

541






What is the model filter?

598


how to create measures and dimensions?

608


plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

1872


What do you mean by drill across?

573


3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2126


What is difference between content store and content manager?

544


How to apply securities for reports in cognos connection?

2112


What is the function of model design accelerator?

536


Explain the characteristics of cognos?

607


What is a Pivot?

542