O'Reilly logo

Data Integration Blueprint and Modeling: Techniques for a Scalable and Sustainable Architecture by Anthony David Giordano

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required