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
What is the difference between view materialized view and view?
How to create different types of templates?
Explain what are the different types of join operations?
Explain how to get the first 100 rows from the flat file into the target?
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?
What is a data warehousing?
What are various warehousing tools?
What is an er diagram?
Explain what are conformed dimensions?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
what are the other factors of the database on which the loading performance depend?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Which component has onread method and what it is used for?
Explain er diagram?