Hi,
I am doing a jdbc to flat file,
I have the below input structure
<row>
<order>
<customerno>
<id>
<sid>
<qty>
<price>
</row>
I need the output file as below
order#customerno#id
sid#qty#price
sid#qty#price
sid#qty#price
order#customerno#id
sid#qty#price
sid#qty#price
order#customerno#id
sid#qty#price
sid#qty#price
order#customerno#id are header fields which occur once and sid#qty#price are details which repeat
how should I desing my output structure and map them,what node functions do I need to use?I am fine doing FCC once the mapping is done
Thanks