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
---------------Describe OLAP Reporting and RDBMS Reporting?
what do u mean by bridge group? where we r using this one?
Can you define drill across?
Can you define folder?
what are the errors faced while bursting the reports and how to solve those errors?
how to merge 2 crosstabs thans
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Which lifecycle we will use for reporting?
What is the complex report you faced in real time?
How to publish a package by running Java Script?
What are types of batch available in cognos?
is cognos 7 is better than cognos 8
Which studio is used to create reports?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
