Fact tables store the quantitative observations along with IDs which will allow

Apr 30, 2021
10:33:59pm

dYrtbYkerYder All-American

them to be joined/linked to the Dimension tables which contain the attributes of the dimensions contained within the data schema.

https://i.stack.imgur.com/aB9k9.jpg

This message has been modified

Originally posted on Apr 30, 2021 at 10:33:59pm

Message modified by dYrtbYkerYder on Apr 30, 2021 at 10:34:41pm

Report problem with this ad

dYrtbYkerYder

Bio page: dYrtbYkerYder
Joined: Sep 27, 2006
Last login: May 3, 2024
Total posts: 22,851 (138 FO)

Report problem with this ad

Messages

Author

Time

Dumb data question: what is a fact table and why would it be useful for an

crazY

4/30/21 9:53pm

It's a way to organize data in a reporting environment

Darzog

4/30/21 9:58pm

So, it's basically just imported data?

crazY

4/30/21 10:13pm

That's how I've always seen it.

Darzog

4/30/21 10:32pm

Thanks. Good to know. I'd never heard the term before today, so I just always

crazY

4/30/21 10:44pm

Fact tables store the quantitative observations along with IDs which will allow

dYrtbYkerYder

4/30/21 10:33pm

So, follow up question to this:

crazY

4/30/21 11:15pm

A few things

Darzog

4/30/21 11:26pm

Following up darzog - you don’t want reporting from source system.

molodyets

4/30/21 11:31pm

And there may be situations where you de normalize it and don’t have them for something in your reporting layer

molodyets

4/30/21 11:32pm

The primary benefit of a fact/dimension data model is to maximize performance,

Megamind

5/1/21 10:55am

That makes sense. Another question:

crazY

5/1/21 11:14am

You would have something like this:

molodyets

5/1/21 11:36am

Typically you generate new IDs when you import data into your warehouse. Any

Megamind

5/1/21 11:40am

I walked away from a job that would have been a $30k year raise because of this

Megamind

5/1/21 12:05pm

This sounds miserable. I wonder how it ended up.

molodyets

5/1/21 12:13pm

It's still going. It happened in January. I'm interested to see how they do.

Megamind

5/1/21 12:31pm

I'm not sure I completely understand what you're asking

Darzog

5/1/21 11:44am

Thank you for participating in this exercise of fact tables for dummies.

Posting on CougarBoard