Interested to Buy Any Domain ? << Click Here >> for more details...
when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 10115 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 |
What is the importance of having monitor service in cognos?
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
What is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
How do we run stored procedure?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
Explain the Difference Between Bursting and Scheduling?
Can you define drill down and drill up?
Whrer u can save the Report net documentation in our local system?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com
5. Which type of report you build more, list, crosstab or chart and why?
Teradata 
