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
What is a real-time data warehouse?
Who needs data warehousing?
What are necessary tasks to install reportnet software?
What is the difference between power center and power mart?
What are Aggregate tables?
What is the difference between snowflake and star schema?
Explain difference between view and materialized view?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
What is degenerate dimension table?
Explain what are non-additive facts?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What are the fundamental elements of the data warehouse?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What are the different methods of loading dimension tables?