Explain what are non-additive facts in detail?



Explain what are non-additive facts in detail?..

Answer / Alka

Non-Additive Facts refer to measures that don't follow the additive property (i.e., if you sum up the values, they do not equal the total). Examples of non-additive facts include rankings, counts with duplicates, and ratios. They are challenging to analyze using traditional OLAP techniques because they require more complex calculations and don't support aggregations like sum or count.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

what is hybrid schema

4 Answers   TCS,


What is meta data and system catalog?

1 Answers  


What is the goal of optimizer?

1 Answers  


suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,


What are fundamental stages of data warehousing?

1 Answers  


What is Cognos script editor?

1 Answers  


What is Grain & Granularity in Data Warehouse.

2 Answers   TCS, TVS,


what are the major three types of modeling used?

1 Answers   InfoAxon Technologies,


What is incremintal loading?

1 Answers  


capital of tamilnadu

6 Answers   Wipro,


What are session timeout and application timeout?

1 Answers  


What are aggregate fact tables ? why they are needed? give an example

2 Answers  


Categories