Question

Populate the tables created in E8.1b with the data. Use the data
that you used to populate the tables shown in Figure 8.42 as the
basis for aggregation.

use CREATE commands to create tables (Fact(s) and Dimensions
tables
use INSERT INTO to populate the above tables
use SELECT * for each table to display the information you
entered in step 2
use DROP commands to erase the tables from the data
warehouse

CALENDAR Dimension Calendar DayOf FullDate DayOfWeek Month 1/1/2013 Tuesday 1/2/2013 Wednesday 2 Month Qtr Janua Janua Q1 Q1 Year 2013 2013 OFFICER Dimension Officer Officer OfficeriD OfficerName Rank Joe Mike Bob Sergeant Patrolman Patrolman 2 TICKETREVENUE Fact table Calendar Officer Amount 1 $300 2 $200 3 $250 2 $150 2 2
CALENDAR Dimension Calendar DayOf FullDate DayOfWeek Month 1/1/2013 Tuesday 1/2/2013 Wednesday 2 Month Qtr Janua Janua Q1 Q1 Year 2013 2013 OFFICER Dimension Officer Officer OfficeriD OfficerName Rank Joe Mike Bob Sergeant Patrolman Patrolman 2 TICKETREVENUE Fact table Calendar Officer Amount 1 $300 2 $200 3 $250 2 $150 2 2


cover image
Seen 1 years ago byGeorge Reece

1 Answer