What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
- 1 Answers
- 1171 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
