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


Please Help Members By Posting Answers For Below Questions

Do you view contain data?

556


Why fact table is in a normal form?

555


Explain what is the difference between power center & power mart?

517


Code the tables statement to produce a multi-level frequency?

544


What is the difference between power center and power mart?

553






Can a dimension table contain numeric values?

594


What is the difference between data warehouse and operational systems?

595


Difference between cold fusion 5 and cold fusion mx 6?

583


What is surrogate key? Explain with examples.

605


What are parallel querys and query hints?

1782


What is the metadata extension?

537


What is the main difference between schema in rdbms and schemas in datawarehouse?

539


Explain what are the different types of join operations?

531


What is the difference between aggregate table and materialized view?

596


What are the reasons to use a chameleon method in data warehousing?

564