This project deals with analysing movie actors data set by designing a cumulative data model.
- Construct a series of SQL queries and table definitions that will allow us to model the actor_films dataset in a way that facilitates efficient analysis.
- This involves creating new tables, defining data types, and writing queries to populate these tables with data from the actor_films dataset.
- Implementing SCD Type 2 and incrementally load new data