So, follow up question to this:

Apr 30, 2021
11:15:44pm

crazY Truly Addicted User

What is the advantage of building reports using fact tables vs connecting to and querying an iseries database with all of the information in the fact table?

Or is the fact table pretty much only necessary for structuring the data?

Report problem with this ad

crazY

Bio page: crazY
Joined: Sep 6, 2010
Last login: Nov 12, 2024
Total posts: 54,563 (30,829 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