when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 8731 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 |
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
Mention the difference between ‘macros’ and ‘prompt’?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
Explain informatica architecture?
where you can save the report net documentation in our local system?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
Hi, I am Searching on Cognos 10, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is asimcognos10@gmail.com. Hope you will help....
How the Bursting happens in same report and how to Print the bursting Report?
What is a Query Subject?
How you will do the estimation for a task?
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,
Teradata 
