I have a XML target which has one recurring element ( minOccurs=1 maxOccurs=unbounded), so depending on some values in parent elements, I need to generate 4 sets or 2 sets of that element under all other parent elements, but I am not able to do it, any idea how to do this?
I am not able to create 4 instances of that element, can we do it??
Please explain the approach. I have gone through Informatica help several times, but no explaination is given for this.
Also for the above situation, we have a pivoting option for the recurring elements in XML sources, but they have clearly mentioned in help that this is not applicable to XML targets, but since this is very common requirement while generating XML targets, i believe something should be available in Informatica.
I read somewhere that using normalizer will help, I tried that, but again its not working, multiple nodes are not getting generated.
Please help!!
Thanks,
Sheela