Many-to-one mapping

In a many-to-one mapping, many sources are selected and assigned to a target. This could be a message source and a database source both mapped onto a common target.

A simple example of a many-to-one mapping is where elements from three different fields in the input are concatenated into a single field in the target, as shown in the following table:
Source Target
Msg
  • a
  • b
  • c
Tbl
  • col1

A second example might involve adding two source values and placing the result into a single target value.

When a many-to-one mapping is performed, you must define how the multiple elements are dealt with when they are placed into the single target element. For example, the source elements might need to be concatenated or have a mathematical function applied to them.

Related concepts
One-to-one mapping
One-sided mapping
One-to-many mapping
Many-to-many mapping
Related tasks
Developing mappings
Adding a many-to-one mapping
Related reference
Mappings