Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13721 Views
- ACS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of join operations?
Explain what is the advantages data mining over traditional approaches?
What is informatica architecture?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain what is batch and describe about types of batches?
Explain normalization?
What is fact less fact table? Where you have used it in your project?
What are the advantages of raid 1, 1/0, and
What is the difference between a primary and secondary actor in use case modeling?
What is mean by aggregate aware?
What is aggregate fact table?
What is the definition of cube in datawarehousing?
What is meta data and system catalog?
How to generate iqd file from framework manager?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
