HOW TO: Load de-normalized data into XML target with repeating groups or multiple occurring elements
Solution:
If the source data is denormalized and they need to be linked to a single repeating group in XML target, you can use Normalizer transformation to normalize the column data into row data and then, link it to the target repeating group.
Attached is a mapping and a sample source file which illustrates this.
