One-to-many mapping

One-to-many mappings assign the same source to many different targets. One-to-many mapping is useful for specific database operations used in DataInsert and DataUpdate nodes because it acts upon a group of related mappings bound together through a single row unification.

This mapping requires user-specified operations to clarify what the relationships are between each target and its sources, and there can be an equal or unequal number of each.

One-to-many mapping is a way to define a message-to-database mapping that uses the WHERE clause. For example:

Source Target
Msg
  • a
Tbl
  • col1
  • col2
  • col3

Related concepts
One-to-one mapping
One-sided mapping
Many-to-one mapping
Many-to-many mapping
DataUpdate mapping
DataInsert mapping

Related tasks
Developing mappings
Adding a many-to-many mapping

Related reference
Mappings