0

4.4kviews

Calculate the maximum number of base fact table records for the values given below:

written 5.6 years ago by teamques10 ★ 68k

•   modified 4.8 years ago

Time period: 5 years

Hotels: 150

Rooms: 750 rooms in each Hotel (about 400 occupied in each hotel daily).

data warehouse and mining

ADD COMMENT FOLLOW SHARE EDIT

1 Answer

4

561views

written 5.6 years ago by teamques10 ★ 68k

•   modified 5.6 years ago

Time period: 5 years

Hotels: 150

Rooms: 750(about 400 occupied in each hotel)

Number of days = 5 X 365 = 1825

Number of rooms = 150 X 750 = 112500

$\therefore$ Number of base fact record

= 1825 X 112500

= 205312500

ADD COMMENT SHARE EDIT