CSPP 53017: Assignment 4
Due on Tuesday, February 26, 2013
Data Model Summary and ETLs
Your report should address the following points:
- Summarize your data model using the intersection matrix concept described in class.
- Does your design include any slowly changing dimensions? How do you plan to handle them?
- Provide 5-10 Source-to-Target Data Maps using the notations
described in class. 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.
You will submit your data summary and ETLs by emailing them as PDF
documents (a single document is also ok) to the instructor. Please,
use the following title for your
submission CSPPDW_P4.
There is no Gradiance Problem Set