Chapter 4. Case Study: Customer Loan Data Warehouse Project

This chapter presents a case study that will be used to demonstrate the life cycle of data integration modeling. For this exercise, we have been tasked with defining, designing, and developing the data integration processes needed to populate a customer loan data warehouse and its associated customer loan reporting data mart tables.

Case Study Overview

Due to new regulatory reporting requirements, a small regional bank known as the Wheeler Bank needs to better understand its overall loan portfolio exposure. Currently, it has disparate customer, commercial loan, and retail source systems that would provide the data needed for the loan reporting requirements. New federal credit loan ...

Get Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.