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

Sign up, and you can customize which countdowns you see. Sign up

Report problem with this ad

May 1, 2021
2:46:02pm

crazY Truly Addicted User

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

Report problem with this ad

crazY

Bio page: crazY
Joined: Sep 6, 2010
Last login: Jun 8, 2024
Total posts: 54,021 (30,400 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

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.

crazY

5/1/21 2:46pm

Report problem with this ad

Posting on CougarBoard

In order to post, you will need to either sign up or log in.

Report problem with this ad