Interested to Buy Any Domain ? << Click Here >> for more details...
when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 9942 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subbu
for huge amount of data snowflake schema is the best.and
for less amount of star schema is better
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / 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 |
Answer / 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 |
Answer / 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 |
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
What is the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,
..Architectural difference between cognos reportnet and cognos8?
What is Cognos Mashup Services .what is the use of Cognos Mashup Services and where to use.
How can we do the unit testing?
How do you call a store procedure within a transformation?
if u generate a cube r pakage then its published we open in cc its ask every time for username &pass word?what we do?the pak r cube was not asking the password? what we do for this problem?pls ans me.............
What is model filter?
What is the use of powerhouse?
Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya
What is meant by junk dimension?
Whrer u can save the Report net documentation in our local system?
Teradata 
