Thursday, 25 October 2012

Where do we use semi and non additive facts? | ETL Testing Interview Questions

Additive: A measure can participate arithmetic calculations using all or any dimensions.
Ex: Sales profit
Semi additive: A measure can participate arithmetic calculations using some dimensions.
Ex: Sales amount
Non Additive:A measure can't participate arithmetic calculations using dimensions.
Ex: temperature

No comments: