Skip to Content
0
Former Member
Jan 20, 2011 at 04:24 AM

Mapping help

25 Views

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