Interested to Buy Any Domain ? << Click Here >> for more details...
when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 10109 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 do you call a store procedure within a transformation?
actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?
what is the difference between querystudio in reportnet and cognos8
What is a Complex report and explain?
Can you define query studio?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
How to create Events?
what is power prompt in cognos ep7series?what is the use of this?
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
What is snapshot ?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
diff b/w grouping and aggregation
Teradata 
