Answer Posted / aq

Because, we use Star schema to analyse the data and for that we need fast access of that data.
if the schema is normalized then it will have more joins and will take more time retrieve the data from source, which will cause the reporting / analysis slow.
Hence to faster access of the data Star Schema is de-normalized

What are the types of studio?

1199

---

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

1101

---

Can you define transformer?

1011

---

how u will design the report if the objects are available

2806

---

----------------------What are the User Securities?

1897

---

What are the different kinds of panes included in cognos?

1104

---

What is the difference between regular dimension and derminant?

2352

---

Explain the difference between powerplay transformer and power play reports?

1077

---

What do you mean by Drill down and Drill Up?

1052

---

What are the components of the report studio?

1244

---

How create measures and dimensions?

1136

---

What are the components used in web tier?

1047

---

What is a Pivot?

1237

---

Define the slice and dice?

1067

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2619

---