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
- 13914 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
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
Explain bus schema?
Explain difference between snow flake and star schema.
What is the difference between view materialized view and view?
Explain difference between e-r modeling and dimentional modeling?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
How to create different types of templates?
List down some of the real time data-warehousing tools?
How to export mappings to the production environment?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How to define a cube??
Explain can a dimension table contains numeric values?
Why we use repository connectivity?
Can decision tree be implemented using SQL?
Explain what is a cube in data warehousing concept?
