Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the two types of framework manager?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What is the enterprise class platform architecture of cognos 8?
-----------------What is Determination Model?
What is difference between primary key and unique key constraints?
Can you define materialized view?
What is the importance of having monitor service in cognos?
What do you mean by drill through report?
What are the types of hierarchies?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate A product manager is analysing the sales made for each
product, he has requested a report containing data for
specific products. To do this we will create a report that
includes a prompt page that filters on specific products
within specific product subcategory and category. how can you get the errors in job? when loops are araised
we get error? what are the dimensions that you have in your current
project?list them? what is the difference between querystudio in reportnet and
cognos8 How to generate cubes in cognos?
