---------- 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 |
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?
what is the difference between filter and condition?
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
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.
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
Why need staging area database for dwh?
What are all the types of indexes in Cognos?
What is the size of database for you project?
write a query to display the third record from the employee table?
What do you understand by the term 'aggregate cache'?