0

4.9kviews

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

written 6.8 years ago by teamques10 ★ 70k

•   modified 5.9 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

580views

written 6.8 years ago by teamques10 ★ 70k

•   modified 6.8 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