Business analysis glossary
Source to Target Mapping
What it is
A source to target mapping is a document, usually a spreadsheet, that lists for each field in a target system or report where its value comes from in the source system and how it is transformed, such as copied directly, converted, combined, looked up or defaulted. It is the specification for integrations and data migrations.
Why it matters
Developers cannot build interfaces or migrations from vague statements like bring the customer data across. A mapping makes every field and rule explicit and testable. Writing one forces analysts to find gaps early, such as a mandatory target field with no source or two systems that use different codes for the same thing.
Example
For the new claims platform, the analyst maps one hundred and twenty fields. Claim status needs a lookup because the old system uses codes O, P and C while the new one uses Open, Pending and Closed. Policy start date must be converted from text to a date. Three target fields have no source and go to the business for a decision.