Dimensions Counted
Posted in cross stitch on 10/25/2010 07:36 pm by adminSuppose that a data warehouse consists of four dimensions date, spectator, location and game and the two?
Suppose that a data warehouse consists of four dimensions date, spectator, location and game and the two measures count and charge, where charge is the fare that a spectator pays when watching a game on a given date. Spectators may be students, adults, or seniors. With each category having its own charge rate.Draw a star schema diagram for the data warehouse.
If you want to find a good example of star schema and description of other things related to data warehouse you can visit datawarehouse4u.info portal.