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 u burst the reports? if u r bursted reports is not reached to destination how u identify???

10734


How to do Performence Tunning in Cognos Reports?

2068


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

729


Define dimensions?

612


What is defined as data mining?

599






---------------Tell me about DWH Concepts?

1603


how to create measures and dimensions?

608


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

1501


how to perform single sign in cognos by using url?

564


What is called materialized view?

587


Explain what is the main advantage of impromptu over cognos reportnet?

599


What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

544


What is the deployment requirements used in cognos?

548


What are slice and dice?

526


How to a create header dynamically in a crosstab report in cognos 8.1?

1985