Data mapping

Examples of direct, conversion, and composition mappings from source to target data.

In computing and data management, data mapping is the process of defining correspondences and transformation rules between data represented in a source model and data represented in a target model. A mapping can specify direct correspondences between data elements as well as transformations such as conversion, concatenation, lookup, or restructuring.

Data mapping is used in data integration, data migration, extract, transform, load (ETL), electronic data interchange (EDI), application integration, and other processes in which data must be exchanged or reconciled between different representations.

For example, a source system might contain fields named first_name and last_name, while a target system expects givenName, familyName, and fullName. A mapping could associate the first two fields directly with their corresponding target fields and define fullName as a concatenation of the two source values.

This page is issued from Wikipedia. The text is available under Creative Commons Attribution-Share Alike 4.0 unless otherwise noted. Additional terms may apply for the media files.