Provide your answers in the comments below
Fictitious company A is running a car rental business. Logical data model (OLTP) for this business is presented below.
In order to analyze branch performance, company A wants to create dimensional data warehouse that covers the following business processes:
- Signed contracts per branch, car, customer, region
- Returned cars per branch, car, customer, region
- Picked up cars per branch, car, customer, region
According to business, data warehouse will be populated at the end of each business day. All dimensions will be of history preserving type.
Please do the following:
- Specify all relevant dimensions (along with each and every relevant columns)
- Define all necessary facts (along with each and every relevant columns)
- Draw logical data model of the resulting Data Marts (along with each and every relevant columns)
- a. Create technical design document that explains how you will load dimensions and fact tables
b. Explain your design for a Full and Incremental Load process
