Answer / vaibhav

A fact-less fact is a fact table in which only primary keys
of the dimension tables are present as foreign keys but no
measure/fact columns.
There are 2 types of factless fact table:
a) Event Tracking Tables: A table that records an event.
Example: A table that records student attendance. It
contains date_key, student_key, teacher_key, course_key,
without any measure section.
b) Coverage Tables: A table to answer questions about
things that didn't happen.
Example: An ordinary fact table cannot answer questions
like "Which products were on promotion that did not sell?",
because it contains only the records of products that did
sell. A table contains date_key, product_key, store_key,
promo_key and without measure section is used to answer
such questions.

Answer / gopal

Fact less fact table does not contains any facts or measures

Ex-student attendance-Yes or No
Gender-M or F

Are you aware of any limitations in Cognos?

1 Answers   HCL,

---

how will optimiz the performance of sql in FM ?

2 Answers   Infosys,

---

Give me any example of semi and non additive measures?

0 Answers  

---

what is the difference between a data item and a query item?

2 Answers   Bodhtree, HP,

---

5. Which type of report you build more, list, crosstab or chart and why?

0 Answers   IBM,

---

How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 Answers  

---

What do you mean by drill through report?

0 Answers  

---

What are the types of studio?

0 Answers  

---

Explain how data modeling is useful to cognos in daily life?

2 Answers  

---

Explain is there any comparison available for cognos reportnet vs crystal reports?

0 Answers  

---

how u provide security to reports??how u provide security to packages ?

5 Answers   Wipro,

---

What are all types of prompt?

1 Answers  

---