Home » Developer & Programmer » Data Integration » Number of Dimensions
Number of Dimensions [message #93214] Wed, 05 November 2003 04:20 Go to next message
Messages: 1
Registered: November 2003
Junior Member
I'm creating a small dwh, may be its a kind of data mart.
Does it make sense to have just 2 dimension-tables and one fact table??

I'm considering different slot-machines containing one or more cartridges with. In the fact-table I want to store the contents of a cartridge (by day).
So my two dimensions are: time and cartridge.
My Fact-Table contains then time-id & cartridge-id
and the appropriate contents per coin-value.

I don't see more dimensions (like region or so).
In fact the slot-machine do have a place which you could use for analysis, but there is a relation between place-machine-cartridge.

Anyone got an idea??

Re: Number of Dimensions [message #93388 is a reply to message #93214] Wed, 20 October 2004 03:13 Go to previous message
Messages: 72
Registered: August 2000
a typical data warehouse must have between 5 - 15 dimensions.. anything lesser or greater to that means a problem..
Previous Topic: Connecting to SQL server DB in OWB
Next Topic: Ask for help-28/10
Goto Forum:

Current Time: Sun Apr 02 06:42:27 CDT 2023