What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
- 6 Answers
- 12532 Views
- ACS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dirasanchu
It is a fact table which does not contain any measurable data.
EX: Student attendance fact (it contains only Boolean
values, whether student attended class or not ? Yes or No.)
| Is This Answer Correct ? | 10 Yes | 1 No |
A Factless fact table contains only the keys but there is
no measures or in other way we can say that it contains no
facts.
Generally it is used to intigrate the fact tables.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / asha
2 purposes of factless fact
1. Coverage : to indicate what did NOT happen. Like to
answer questions like which product did not sell well in a
particular region.
2. Event tracking: To know if the event took place or not.
Like: Fact for tracking students attendence will not
contain any measures.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / pratap gangula
Factless fact table contains only foreign keys. We can have two kinds of aggregate functions from the factless fact one is count and other is distinct count.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / asish
factLess fact table def as mentioned above..
Where it is used?
These are used particularly to resolve many to many
relationships,which will create duplicate counts in OLAP
Cube creation.
Or it can be used to avoid loops which will decrease the
query performnce while reporting
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / eswar
Factless fact tableis used for the converting the star
schma into snowflake schema
| Is This Answer Correct ? | 0 Yes | 14 No |
What is the use of incremental aggregation? Explain me in brief with an example?
Explain ddl (data definition language)?
Describe the differences between a data warehouse and data mart.
Explain piconet?
What are different stages of ?Data mining??
What is difference macros and prompts?
What is Active Datawarehousing?
What is vdl (view definition language) explain?
How can we import and export using BCP utility?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
How do you define data block size?
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
Teradata 
