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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.