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

Report problem with this ad

Apr 30, 2021
11:32:51pm

molodyets Mortgage guy in all 50 states

Report problem with this ad

molodyets

Previous username: patches1391
Bio page: molodyets
Joined: Mar 26, 2006
Last login: May 3, 2024
Total posts: 43,236 (19,300 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