Required

i.By examining the Dimension tables and the Fact table, describe the grain of the data warehouse.

ii.An ETL process is required to construct the main fact table (SalesFact) from the operational data sources (see below). Give a narrative explanation of how this might work.In your explanation you may use SQL-style language or functions or calculations.

iii.Explain how the Week column in the TimeDim table might be calculated.

ServiceDim TimeDim ServiceKey Name Category Regulated? Timekey Month Week 100 Pension plan Pensions Yes 0 01 110 AVC Pensions No DOE 115 Term Account Savings Yes 10 SalesFact Service Time Broker Euro sales Qty_Sales 110 0 01 B1 8500 20 115 001 B2 1200 0 18 110 DOE 81 9500 23 BrokerDim Brokerkey Broker_Name Specialism Area 81 Alne Kilbane AVC Law Connaught 82 Mary Devine Leinster 83 Elmear Smyth Banking Leinster