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

What is the difference between view materialized view and view?

692


How to create different types of templates?

602


Explain what are the different types of join operations?

622


Explain how to get the first 100 rows from the flat file into the target?

598


How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

626






What is a data warehousing?

703


What are various warehousing tools?

657


What is an er diagram?

710


Explain what are conformed dimensions?

651


What are situations where snowflake schema is better than star schema when the opposite is true?

639


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

561


what are the other factors of the database on which the loading performance depend?

1564


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

627


Which component has onread method and what it is used for?

598


Explain er diagram?

640