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 / pratap gangula
Factless fact table contains only foreign keys. We can have two kinds of aggregate functions from the factless fact one is count and other is distinct count.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is degenerate dimension table?
What is Analysis Services?
How to join 3 database like flat file, oracle, db2 in informatrica?
Explain normalization?
What are the different types of datawarehosuing?
What is a general purpose scheduling tool?
How to define a cube??
Explain the difference between filter and conditin?
What is operational data store (ods)?
Explain me what are data marts?
Code the tables statement to produce a multi-level frequency?
What is pre-emptive and non-pre-emptive?
What are cluster analysis in data warehousing?
How can you set the session management?
What are the reasons to use a chameleon method in data warehousing?