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
Do you view contain data?
Why fact table is in a normal form?
Explain what is the difference between power center & power mart?
Code the tables statement to produce a multi-level frequency?
What is the difference between power center and power mart?
Can a dimension table contain numeric values?
What is the difference between data warehouse and operational systems?
Difference between cold fusion 5 and cold fusion mx 6?
What is surrogate key? Explain with examples.
What are parallel querys and query hints?
What is the metadata extension?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what are the different types of join operations?
What is the difference between aggregate table and materialized view?
What are the reasons to use a chameleon method in data warehousing?