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
- 13995 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
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
How to provide security in frame work manager for a query subject?
What is bi?
What is aggregate fact table?
What is metadata in context of a datawarehouse and how it is important?
What is a data profile?
Is there any default username & pwd for bo designer & supervisor?
Explain what are the different methods of loading dimension tables?
what are relationships?
Explain what are non-additive facts?
Explain what are components of report studio?
Explain what are the advantages and disadvantages of reporting directly against the database?
what are the different views that are considered when building an object-oriented software system?
How to create context?
