MPCS 53017: Data Model Summary and ETL

Data Model Summary

• Based on your revised proposal and your current star schemas, summarize your data model using the intersection matrix concept described in class. Please, name the file with your intersection matrix table matrix.pdf.

• Does your design include any slowly changing dimensions? How do you plan to handle them? Please, name the file with your explanation slowly.txt.

Extract, Transform, Load (ETL) process

• Provide 5-10 Source-to-Target Data Maps using the notations described in class. Please, name the file with your maps ETLmaps.pdf

• How do you plan to implement these transformations? Can any of them be expressed directly in SQL, and if so, provide 2-4 queries or sequence of queries that implement them. Please, name the file with your maps ETLqueries.txt

You will submit your proposal via phoenixforge. Please, add all of the relevant files (matrix.pdf, slowly.txt, ETLmaps.pdf, ETLqueries.txt) in the reports directory and commit them.

Instructions on how to use phoenixforge are available here