What is Factless fact table? In which purpose we are using
this in our DWH projects?Plz give me the proper answer.
Thanks,
Ramesh
Answer Posted / samir kumar sahoo
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 |
Post New Answer View All Answers
What is a staging area? Do we need it? What is the purpose of a staging area?
what is user variable in affinium campaign? and some real time examples.
What is a relationship?
What is the difference between mapping parameter & mapping variable in data warehousing?
What is informatica architecture?
What is the difference between er modeling and dimensional modeling?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
How can we schedule the graph in unix?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain functional dependency?
What is index awareness in universe?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are non-additive facts in detail?
What is Star Schema?
Explain vldb?