Answer / Kapil Kumar Jain

DWH (Data Warehouse) is a large, centralized repository of data that is used for reporting and analysis. A DWH consists of a series of tables and databases that are optimized for querying and analysis, rather than transaction processing. DWH concepts include data modeling, ETL (Extract, Transform, Load), and star schema.

2. What functional area you worked on.

1 Answers   IBM,

---

What is a Datastore in Cognos?

1 Answers  

---

how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,

---

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

1 Answers   Wipro,

---

Why cognos decision stream is used?

1 Answers  

---

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1 Answers  

---

What is a Pivot?

1 Answers  

---

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

---

how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  

---

what is model and say about process how to create model and how to test model?

1 Answers   IBM,

---

How can you schedule a report based on different time zone ?(ex: local time should be same as 10 am . Japan should get the report at 10 am. USA should get the report at 10 am).Is that possible?

1 Answers   HCL, iGate,

---

Define the slice and dice?

1 Answers  

---