100%(9)9 out of 9 people found this document helpful
This preview shows page 1 - 2 out of 5 pages.
Solution for Lab Task1.The dimensions in the problem somewhat difficult because dimensions should be combinedin data sources. Item and customer combine parts of both data sources. The calendardimension is a standard, hierarchical dimension. Email can be parsed to be hierarchical aspart of the customer dimension.FranchiseoFranchId: retail database onlyoFranchRegion retail database onlyoFranchPostalCode: retail database onlyoFranchModelType: retail database onlyoFor the special events worksheet, selected franchises maintain spreadsheets so thefranchise will be derived from the spreadsheet submission.CalendaroDate columns in the retail database (SaleDate, ServPurchDate, and MmbrDate) andspreadsheet (EventDate); hierarchical (yearmonthday)Item: combines Merchandise, Service, and EventsoItemId (Merchandise table) | ServCatId (ServiceCategory table)oItemName (Merchandise table) | ServCatName (ServiceCategory table) |MemberTypeName (MemberType table) | Event Name (spreadsheet)oItemType (Merchandise table) | ServiceCategory table |Event Type Code(spreadsheet)Customer: combines members and corporate customersoMmbrId (Member table) | Corporate Customer Id (spreadsheet)oMmbrName (Member table) | Corporate Customer Name (spreadsheet but must beparsed, because two values are stored in same column in spreadsheet)oCorporate Customer Location (spreadsheet): must be parsedoMmbrEmail: retail database (Member table); hierarchical (top level domainsecondlevel domainlocal part)o