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 on a group of related mappings that are 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
|
Tbl
|