CODEWITHSUNDEEP
databasedatabase-designdata-structuresdata-warehouseetl
fenix
fenix

Reputation: 1746

Structuring the data warehouse?

I need an advice for creating my DW. I have some experience in creating DW (using Pentaho as BI server), I made an array of scheduled database queries which creates 4 dimension tables and 1 fact table (for sales reports). Now, there is a need for spreading out DW (for import, warehouse, logistic reports), so my question is:
Do I have to make more fact tables for each department (and dimension tables for those), or there is some other structuring model?
Of course, this time it will be done using ETL tool, but need general advice.

Thanks, Stevan

Upvotes: 0

Views: 206

Answers (1)

Neil McGuigan
Neil McGuigan

Reputation: 48287

A fact table represents a process or events that you want to analyze.

If there is not a new process or event that you want to analyze, then you do not need a new fact table.

Perhaps you could give us some more details about what you are analyzing...

Upvotes: 1

Related Questions