Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 15 September 2013

Types of Facts in Data warehouse


By on 11:55:00

A fact table is a table that contains the measures of business.


Types of Facts

There are three types of facts:
  • Additive:
 Additive facts are facts that can be summed up through all of the dimensions in the fact table.

Example: Take three types of facts. assumes that we are in shop, and we have a fact table with following  columns

Additive Fact
Additive Fact

If you see this table it is used to record the sales amount of shop by date,store and product.

The column Sales amount can be get summed up on each level of its dimensional (date,store,product).

The sales amount is called additive fact because it can be summed up through all of the dimensions in the fact table
  • Semi-Additive:
Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.

Example: Consider you are in bank and you have the following table

Semi-Additive
Semi-Additive

The purpose of this table is to have current balance by account by end of each day. 

We can sum up the current balance of each account, and it will not make sense if we sum the current balance by date. So this table is called semi-additive fact.
  • Non-Additive:
Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.


Example : I can use same table of semi-additive fact as example for non-additive.

Non-Additive
Non-Additive
In this table profit margin is non-additive as we can't sum up profit margin either by account or date, so profit margin we can consider as non-additive fact.


5 comments:

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)