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 |
what is hybrid schema
What is meta data and system catalog?
What is the goal of optimizer?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What are fundamental stages of data warehousing?
What is Cognos script editor?
What is Grain & Granularity in Data Warehouse.
what are the major three types of modeling used?
1 Answers InfoAxon Technologies,
What is incremintal loading?
capital of tamilnadu
What are session timeout and application timeout?
What are aggregate fact tables ? why they are needed? give an example