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
- 12520 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 is data warehosuing hierarchy?
How can you import tables from a database?
How can you set the session management?
What are the mapping paramaters and maping variables?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what is data validation strategies for data mart validation after loading process?
what type of raid setup would you put your tx logs?
What are situations where snowflake schema is better than star schema when the opposite is true?
The same tier?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain what is the difference between datawarehouse and bi?
How to know the time taken for particular report execution?
What are the various methods of getting incremental records or delta records from the source systems?
Why fact table is in a normal form?
What is data type of the surrogate key?
