Different Types of FACT TABLE IN DATA WAREHOUSE?

There are 3 types of fact s are available in fact table

  1. Additive facts
  2. Semi additive facts
  3. Non additive facts

 ADDITIVE FACTS:

If there is a possibility to add some value to the existing fact in the fact table .that facts we called  as additive fact.

 SEMI ADDITIVE FACT:

 If there is possibility to add some value to the existing fact up to some extent in the fact table is we called as semi additive fact.

 NON ADDITIVE FACT:

If there is not possibility to add some value to the existing fact in the fact table is we called as Non additive fact.

Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*