---------- Purpose of Factless Facttable?
Answers were Sorted based on User's Feedback
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 |
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 |
what is requery in cognos?
write a query to display to 10 max record from the employee table?
what is cube size?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
Can you define pivot?
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
what are the dimensions that you have in your current project?list them?
Can you explain new content durability?
what is hints in cognos and where we use it.
Main Differnce between Cognos7 and Cognos8
Define the slice and dice?
Explain the Difference Between Bursting and Scheduling?