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