Appendix B. Data Integration Guiding Principles
This appendix contains the guiding principles of data integration that were referenced throughout the book.
Write Once, Read Many
There is a reason why source system owners are so cranky. It is often the result of requests for multiple extracts from their source systems for the same data. One of the major issues in terms of cost and maintenance data integration is the number of uncontrolled, undocumented, and duplicative data integration extraction routines for the same data. The goal is to have one data integration component per source type (flat file, relational, etc.).
Grab Everything
When developing extract requirements, it is easy to focus on only extracting the fields needed for the intended ...
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.
