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


Please Help Members By Posting Answers For Below Questions

For faster process, what we will do with the universe?

655


What are algorithms provided by Microsoft in SQL Server?

1644


How to create different types of templates?

602


Explain vldb?

707


How are models actually derived?

1634






What are cluster analysis in data warehousing?

658


What is degenerate dimension table?

649


What are the different types of datawarehosuing?

631


Explain is olap databases are called decision support system true/false?

638


How to join 3 database like flat file, oracle, db2 in informatrica?

716


What are the different types of join operations?

642


Difference between cold fusion mx 6 and cold fusion mx 7?

537


What are steps we have to follow in designing the userfriendly universe?

627


What is the definition of cube in datawarehousing?

643


What are the advantages and disadvantages of reporting directly against the database?

618