when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 9014 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satya/gunu(satyabadi)
=>
-Star schema is highly denormalized.
-Snowflake schema is normalized.
=>
-As star schema is denormalized, the size of DWH will be larger than that of Snowflake schema.
=>
-Performance wise, star schema is good.
-But if memory utilization is a major concern,then snow flake schema is better than star schema.
=>.. In addition, Generally in real time, we use Snowflake schema only.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define datastores in cognos?
-------------How you design DWH?
What is difference between primary key and unique key constraints?
-----------------What is Determination Model?
How can I schedule reports in cognos?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What is a Folder?
Can you define a datastore in cognos?
Can you define query studio?
What junk dimension contains?
What is the use of powerplay web viewer in cognos?
What is called materialized view?
What is the difference between Open Connection command ang Open Session Command?
What is called a slice?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
