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
How to create a cube in Transformer? What is the process? Please mention process thank u
5. Which type of report you build more, list, crosstab or chart and why?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is the difference between a cascading report and drill through report?
Can you define set to be cardinality?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
What are various types of gateways in cognos?
--------------Explain Table of contents?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is a Cube?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Why cognos decision stream is used?
What is a Pivot?
-----------------What is Direct and Conventional loading?
whats the difference between previous version of cognos and cognos 8 BI?