MapExampleNestedTablesToFlatStructure 

Problem

In this example, the Person record in the source structure contains several telephone numbers for the person. To map this structure to a target structure that contains the telephone numbers for the same person in different flat records for the person, the fields Id and Name from the source structure have to be replicated accordingly.

Solution

·        The target message should contain the exact same number of person records as there are telephone numbers. Therefore, you assign the target field TelephoneNumber to the source field Person.

·        You then replicate the Id and Name fields of the source message as often as required by means of the standard function useOneAsMany. The target-field mapping for the target field Name looks as follows (the target-field mapping for the target field Id looks the same):

See also: useOneAsMany

·        Since the number of telephone numbers is the same, simply assign the source field TelephoneNumber to the target field TelephoneNumber.