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

Appendix A. Chapter Exercise Answers

Chapter 1 Answers

Question 1

What is the formal definition of data integration?

Data integration is a set of maturing processes, techniques, and technologies used to extract, restructure, move, and load data in either operational or analytic data stores either in real time or in batch mode.

Question 2

What are the three issues in the Introduction that are caused by the complexity of simply integrating the Loan Type attribute for commercial loans and retail loans into a common Loan Type field in the data warehouse?

Issue 1. Matching and confirming the fields to the EDW loan type

Issue 2. Conforming the types and sizes of the field length

Issue 3. Conforming different loan types into one field (e.g., ...

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