1 / 9

Data Warehouse

Data Warehouse. Additional Notes. Transient vs Periodic Data Exercise – Sales Data on 28/11/2013. Transactions. On 29/11/2013- These transactions were executed Item 002 changed it sales number to 47 Item 004 was deleted On 30/11/2013 - These transactions were executed

marah-madden
Download Presentation

Data Warehouse

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehouse Additional Notes

  2. Transient vs Periodic Data Exercise – Sales Data on 28/11/2013

  3. Transactions • On 29/11/2013- These transactions were executed • Item 002 changed it sales number to 47 • Item 004 was deleted • On 30/11/2013 - These transactions were executed • Item 001 increased sales to 69 • Item 005 was added – Item name: Chips, quantity sold: 57

  4. Produce the transient table for 29/11/2013 Final transient table for 29/11/2013 • On 29/11/2013- These transactions were executed • Item 002 changed it sales number to 47 • Item 004 was deleted

  5. Produce the periodic table for 29/11/2013 • On 29/11/2013- These transactions were executed • Item 002 changed it sales number to 47 • Item 004 was deleted C = Create/Copied D= Deleted U = Updated

  6. Produce the transient table for 30/11/2013 • On 30/11/2013 - These transactions were executed • Item 001 increased sales to 69 • Item 005 was added – Item name: Chips, quantity sold: 57

  7. Produce the periodic table for 30/11/2013 • On 30/11/2013 - These transactions were executed • Item 001 increased sales to 69 • Item 005 was added – Item name: Chips, quantity sold: 57

  8. Consider this scenario and come out with a star schema • ABC Shoes Store would like to have statistics on their shoes over certain period of time according to shoes quantity_sold, units_sold and color_sold. • These are the related tables involved: • Product: Product_Code, Description, Color, Size • Period: Period_Code, Year, Quarter, MOnth, Day • Store: Store_Code, Store_Name, City, Telephone, Manager • Produce a fact table for this star schema. • Hint: Fact table must consist of Primary Key and if exist – the foreign key. Next the fact table must also include all the analysis/statistics/information that the company would like to process

  9. ABC Technologies would like to have statistics on their shoes over certain period of time according to shoes quantity_sold, units_sold and color_sold Statistics Product_Code Store_Code Period_Code Quantity_sold Unit_sold Color_sold

More Related