Techniques for metadata value-based mapping during data load in data integration job

A system comprising:

• one or more processors;
• and one or more computer-readable media including instructions that, when executed by the one or more processors, cause the one or more processors to initiate operations comprising:
• receiving each of a first data set from a source system and computer-readable instructions to load the first data set into a target system;
• receiving a first metadata set from the target system, the first metadata set associated with a second data set stored at the target system, and the first metadata set describing destinations at the target system;
• comparing data values in the first data set with metadata values in the first metadata set;
• identifying a first data value of the data values that matches a metadata value of the metadata values based at least in part on the comparison, the first data value having a same value as the metadata value and being associated with a second data value of the first data set;
• storing a data integration mapping comprising a mapping of the second data value to a data field associated with the metadata value, the data integration mapping being generated based at least in part on identifying the first data value and the metadata value;
• and
• loading the second data value into the data field pursuant to the mapping and the computer-readable instructions.

One or more non-transitory media having instructions which, when executed by a processor, causes the processor to initiate operations comprising:

• receiving a first data set from a source system and computer-readable instructions to load the first data set into a target system;
• receiving a first metadata set from the target system, the first metadata set associated with a second data set stored at the target system, and the first metadata set describing destinations at the target system;
• comparing data values in the first data set with metadata values in the first metadata set;
• identifying a first data value of the data values that matches a metadata value of the metadata values based at least in part on the comparison, the first data value having a same value as the metadata value and being associated with a second data value of the first data set;
• receiving a data integration mapping comprising a mapping of the second data value to a data field associated with the metadata, the data integration mapping being generated based at least in part on identifying the first data value and the metadata value;
• and
• loading the second data value into the data field pursuant to the mapping and the computer-readable instructions.