1.

How Many Types Of Facts Are There And What Are They?

Answer»

There are three TYPES of facts

  1. ADDITIVE fact: a fact which can be summarized by any one of dimension or all dimensions EX: QTY, REVENUE
  2. Semi additive fact: a fact which can be summarized for few dimensions not for all dimensions. ex: current balance
  3. Non additive fact: a fact which cannot be summarized by any of dimensions. ex: percentage of profit

There are three types of facts



Discussion

No Comment Found