O'Reilly logo

Practical Data Migration by Johny Morris

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

A5 DATA MAPPING EXAMPLE

The following mapping example aims to populate a target system equipment register as described in Table A5.1 within an ERP application.

You can see the fields that need to be populated (mandatory) from a target system viewpoint. This is, however, only the technical view of ‘mandatory’. Although the target system might allow you to create records with some fields unpopulated, the business processes mandate the completion of many other fields. You would also like to provide as rich a dataset as possible, so in the course of your analysis you have found source data for as many fields as possible. Looking at Table A5.1 field by field:

  • Equipment ID – This is a system-generated unique key, so you do not have to provide any ...

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