Answer Posted / subbu

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

how can you get the errors in job? when loops are araised we get error?

2109

---

Define olap designer?

1117

---

What is zero-foot print?

1008

---

What is a dimension?

1019

---

How to test a cube?

2169

---

What is difference between page break and section report?

1201

---

Explain informatica architecture?

985

---

What is meant by drill down?

970

---

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

2068

---

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2073

---

How can you link a query to a data container manually in Report Studio?

2342

---

What is difference between primary key and unique key constraints?

977

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4719

---

What is the function of model design accelerator?

942

---

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

1041

---