SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

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.

CHECK BEFORE CONTINUING

Keep your work safe