Answer Posted / 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.

Can you define metrics designer?

1105

---

What are all the types of report?

1134

---

What is the size of the cube?

1025

---

What do you understand by the cognos?

1019

---

9. What was the most complex type of report you dealt with?

2282

---

Can you define snapshot?

988

---

---------------Tell me about DWH Concepts?

2220

---

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2048

---

Can you define pivot?

1203

---

Define the slice and dice?

1067

---

What is Metrics designer?

1081

---

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4641

---

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

2417

---

Can you define query studio?

1013

---

What do you understand by user class in cognos?

993

---