---------- Purpose of Factless Facttable?

Answers were Sorted based on User's Feedback



---------- Purpose of Factless Facttable?..

Answer / kalyani

According to Kimball

"Factless fact table are the preferred method of recording
the events in the DW where there is no natural numeric
measurement associated with the event. Factless fact tables
also are used to gurantee coverage"

Is This Answer Correct ?    0 Yes 0 No

---------- Purpose of Factless Facttable?..

Answer / kalyani

A factless fact is a fact table in which only primary keys
of the dimension tables present as foreign keys but no
individual fact clomuns.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Cognos Interview Questions

How can we change any header or footer for a group of reports

1 Answers   Satyam, Tech Mahindra,


What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

2 Answers  


what is the difference between filter and condition?

0 Answers   IBM,


What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

2 Answers   DELL,


what are the limitations of cognos reportnet?

11 Answers   IBM, Nestle, TCS,






How to schedule the report in Cognos? And i have 2 users u1,u2. how to schedule the report for these 2 users(the 2 users will get result once for a week) but u1 get the result on every monday to his inbox,and u2 get the result on every wednesday to his inbox.

3 Answers   UHG,


Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,


Why need staging area database for dwh?

0 Answers  


What are all the types of indexes in Cognos?

0 Answers  


What is the size of database for you project?

0 Answers   Accenture,


write a query to display the third record from the employee table?

4 Answers   HCL,


What do you understand by the term 'aggregate cache'?

0 Answers  


Categories