Lab+Task+Solution.doc - Solution for Lab Task 1. The...

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

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
saad
Tags
Star schema, Fact table, retail database, RevFact

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture