Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
- 1 Answers
- 1027 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rina Kumari
Semi-additive and factless facts are special types of data that cannot be easily aggregated across all dimensions in a multidimensional data model. Semi-additive facts can be aggregated only along certain dimensions (e.g., time) and remain constant for other dimensions, while factless facts have no numeric values but provide additional contextual information (e.g., a flag indicating whether a customer is a VIP). These types of facts are used in scenarios where traditional fact tables may not be sufficient to represent the complexity of the business requirements or data relationships.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
