Answer / subbu

for huge amount of data snowflake schema is the best.and
for less amount of star schema is better

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.

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.

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.

How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,

---

How to do deployment?

5 Answers  

---

tell me the creation of Snapshots?

2 Answers  

---

What are the different types of reports present in cognos?

0 Answers  

---

write a query to display to 10 max record from the employee table?

7 Answers   HCL,

---

What are the differences between Cognos ReportNet 1.1, Cognos 8? and enhancements in cognos 8?

1 Answers   IBM, iFlex, TCS,

---

What is the difference b/w macros and prompt?

0 Answers  

---

What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,

---

if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?

2 Answers   CTS,

---

how to convert crosstab into list?

4 Answers   TCS,

---

1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?

1 Answers   IBM,

---

what is the security module used in cognos?

2 Answers   Cognos, IBM,

---