Mindmajix

Types of Facts

1) Addictive Type:

Measurements in a fact table that can be summed up across all dimensions

Consider the following retail fact table:

Screenshot_4

Store wise sales

Screenshot_5
P
roduct wise sales

Screenshot_6

Daily Sales

Screenshot_7

2) Semi Addictive Fact:

Measurements in a fact table that can be summed up across only few dimensions keys Following table is used to record current balance and profit margin for each id at a particular instance of time (Day end)

Screenshot_8

In the above table we cannot sum up current balance across Acct Id

If we ask balance for Id 21653 we will say that 22000 not 22000+80000

3) Non addictive fact:

Facts that cannot be summed up across any dimension key

Note: % and ratio columns are non addictive facts

4) Factless fact table:

A fact table without any measures is called factless fact table

  • It contains only keys
  • It acts as bridge between dimension keys

0 Responses on Types of Facts"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.