DATA GAP ANALYSIS
As I indicated earlier, I am a devotee of data modelling when it comes to data migration. What I present here are some (reasonably) simple examples of how to use data models to spot data gaps and how to use data models to help bridge them.
Data gap analysis should be a first-order task before the detailed Data Mapping occurs. As we shall see, it informs our selection and navigation rules. By taking the ‘helicopter view‘ that data modelling provides we can confront gaps in the legacy data early. And the earlier we confront them, the better. There are, however, limitations to data modelling:
It can only verify that the structure is correct, it cannot perform a Reality Check.
It cannot necessarily reveal that look-up data matches ...
Get Practical Data Migration 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.
