Types of Facts | Data Warehouse Concepts

Share this & earn $10
aroundBI
Published at : 19 Jan 2021
44447 views
491
20

In this tutorial, we will walk through different types of fact. The nature of aggregation of facts for dimensions divides Facts into 3 groups that we can call 3 different fact types:
1. if fact can be summed up for all dimensions in then it is called Additive Fact.
2. if it can be summed up for some dimensions in table but not all then it is semi-additive fact and
3. if it cannot be summed up for any of the dimensions present in the table then it is non-additive fact.
DimensionFactTypes of facts

Wild - Teaser

Wild - Teaser

Key points to know

Key points to know

ELF FISHY

ELF FISHY

Administrative Procedure Act

Administrative Procedure Act

The Cranberries- The Concept

The Cranberries- The Concept

Eminem - Higher (Lyrics)

Eminem - Higher (Lyrics)

Ruel - Dazed & Confused (Official Video)

Ruel - Dazed & Confused (Official Video)

【微辣】女朋友生病了怎麽辦?|微辣Manner

【微辣】女朋友生病了怎麽辦?|微辣Manner

Hydrology Lesson 1: Introduction to Hydrology and what hydrologists usually do | Tutorial Video

Hydrology Lesson 1: Introduction to Hydrology and what hydrologists usually do | Tutorial Video

So what exactly are white people superior at? (Reaction)

So what exactly are white people superior at? (Reaction)

Top 5 Things the Remarkable 2 does Better!

Top 5 Things the Remarkable 2 does Better!

How Many Friends

How Many Friends

How to Fix the "Windows Cannot Automatically Detect This Network's Proxy Settings" Error

How to Fix the "Windows Cannot Automatically Detect This Network's Proxy Settings" Error

Abandoned building in west end engulfed in flames

Abandoned building in west end engulfed in flames

The Pleased - We are the Doctor

The Pleased - We are the Doctor

I've never seen this perfect CNC working process before. Excellent factory machine and technology

I've never seen this perfect CNC working process before. Excellent factory machine and technology

Temples - A Question Isn't Answered

Temples - A Question Isn't Answered

'Burden Of Proof' Against Masood Azhar Not On Us, India Tells China

'Burden Of Proof' Against Masood Azhar Not On Us, India Tells China

The Issue With Longevity...

The Issue With Longevity...

An efficient nectar mop

An efficient nectar mop

I HATE DEEP WATER GAMES WHY AM I PLAYING THIS | Raft Gameplay (Update)

I HATE DEEP WATER GAMES WHY AM I PLAYING THIS | Raft Gameplay (Update)

Paparazzi January 2021 Fashion Fix Auto Subscription. 5 TIPS To Help With Selling & Staying ACTIVE

Paparazzi January 2021 Fashion Fix Auto Subscription. 5 TIPS To Help With Selling & Staying ACTIVE

R.E.M. - Nightswimming (Official Music Video) [British Version]

R.E.M. - Nightswimming (Official Music Video) [British Version]

Organic Dairy Cow Herd Update: Pregnancy & Milk Tests, Frost-free Water, Barn, Winter Paddocks, Hay

Organic Dairy Cow Herd Update: Pregnancy & Milk Tests, Frost-free Water, Barn, Winter Paddocks, Hay

The secrets of learning a new language | Lýdia Machová

The secrets of learning a new language | Lýdia Machová

Know your Portion Size

Know your Portion Size

Vital Signs - The Boys And Girls Are Doing It

Vital Signs - The Boys And Girls Are Doing It

Concentrate

Concentrate

What Is Your MAGIC Power?

What Is Your MAGIC Power?

O Grinch - "You’re a Mean One, Mr. Grinch" Lyric Video

O Grinch - "You’re a Mean One, Mr. Grinch" Lyric Video

10 UNSETTLING Discoveries In Africa Nobody Can Explain!

10 UNSETTLING Discoveries In Africa Nobody Can Explain!

Haven't Been Here For 3 Months! Hoping The Store Is STOCKED! Thrift With Me!

Haven't Been Here For 3 Months! Hoping The Store Is STOCKED! Thrift With Me!

Wait a Minute! - Willow Smith lyrics

Wait a Minute! - Willow Smith lyrics

If You're Seeing This Your Future is about to Change! | PICK A CARD - Psychic Tarot Reading

If You're Seeing This Your Future is about to Change! | PICK A CARD - Psychic Tarot Reading

The fact of the matter is Joe Biden has ‘lost it’

The fact of the matter is Joe Biden has ‘lost it’

ESOcast 225 Light: ESO Telescope Captures Disappearance of Massive Star

ESOcast 225 Light: ESO Telescope Captures Disappearance of Massive Star

RS061: Cricket - The Partiality Of KSCA

RS061: Cricket - The Partiality Of KSCA

Acute and Chronic Conditions: What's The Difference?

Acute and Chronic Conditions: What's The Difference?

How To Sew a Headband | #DIY How to sew a wide headband | Sewing Project for beginners

How To Sew a Headband | #DIY How to sew a wide headband | Sewing Project for beginners

Khan Twinz- Sundown ft. 6ixlo (Lyrics)

Khan Twinz- Sundown ft. 6ixlo (Lyrics)

Pourquoi les SUCCÈS dans les Jeux Vidéo c'est SUPER IMPORTANT ?

Pourquoi les SUCCÈS dans les Jeux Vidéo c'est SUPER IMPORTANT ?

Easy SMALL TALK tips in English: English Speaking Practice

Easy SMALL TALK tips in English: English Speaking Practice

THE BLACK SCORPIO UNDERGROUND - "DESICCATED AND REVERED"

THE BLACK SCORPIO UNDERGROUND - "DESICCATED AND REVERED"

Save Your Marriage While Separated: Do This!

Save Your Marriage While Separated: Do This!

Bob Dylan   Most of The Time

Bob Dylan Most of The Time

Ty Dolla $ign - By Yourself (feat. Jhené Aiko & Mustard) [Lyric Video]

Ty Dolla $ign - By Yourself (feat. Jhené Aiko & Mustard) [Lyric Video]

Will it blend? Silly Vitamix, Plungers Are for Toilets

Will it blend? Silly Vitamix, Plungers Are for Toilets

Music Theory: Introduction to Twelve-Tone Serialism

Music Theory: Introduction to Twelve-Tone Serialism

Jankos - UDYR GUIDE, YOU SHOULD DEFINITELY TRY IT! 🙉⚡

Jankos - UDYR GUIDE, YOU SHOULD DEFINITELY TRY IT! 🙉⚡