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 the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3554

---

i was asked what are the caluclations done by you in your report? plz give reply

2124

---

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1887

---

What is the function of model design accelerator?

903

---

How to generate cubes in cognos?

905

---

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

2368

---

What is model filter?

1104

---

what are the special features in cognos reportnet?

999

---

What are the advantages of using cognos sql?

1124

---

how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11607

---

How is possible this scenario using in type-in prompt.?

992

---

my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4127

---

What is meant by Reportstudio shortcut?

2126

---

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

1110

---

faq's on cognos

3999

---