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

0

4.1kviews

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

written 5.0 years ago by

teamques10 ★ 64k

• modified 4.2 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 EDIT

1 Answer

4

534views

written 5.0 years ago by

teamques10 ★ 64k

• modified 5.0 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 EDIT

Please log in to add an answer.