What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
- 1 Answers
- 1174 Views
- I also Faced
- E-Mail Answers
Answer / Brij Mohan Singh
Semi-additive facts and factless facts are types of measures used in fact tables in data warehousing. nnSemi-additive facts can be aggregated across time but not across all dimensions. For example, a measure like 'Average Sales' is semi-additive because it can be calculated for each month, but not for multiple regions at once.nnFactless facts are measures that do not have a fact key and cannot be used to uniquely identify rows in the fact table. Examples include product categories or company divisions. They are useful when you want to associate attributes with factless entities without creating separate tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the types of dimension tables
What is difference between a connected look up and unconnected look up?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is a linked cube?
Difference between PowerPlay transformer and power play reports?
What are the steps involved in designing a fact table?
List down some of the real time data-warehousing tools?
Explain what is type 2 version dimension?
Explain what are the vaious etl tools in the market?
Explain what are components of reportnet?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is the difference between ods and oltp?
Teradata 
