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
Why is business intelligence (bi) important in data warehousing?
What is metadata in context of a datawarehouse?
How to pivot row data using informatica?
What is the difference between ods and oltp?
What is the difference between metadata and data dictionary?
Why should we use data ware housing and how can you extract data for analysis with example?
What is execution plan?
What is the difference between olap and datawarehosue?
What is dimensional modelling?
What is the purpose of Dataware Control?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
How to import vsam files from source to target. Do we need a special plugin?
What is data analysis? Where it will be used?