Hi Friends,

I have a requirement of storing a xml data as multiple records in oracle table.

Here is my sample input:


ABC
City

A-1
B-1
C-1

....
.
.
.


I want this to be inserted in my table
as follows
storename storelocation partnum
ABC City A-1
ABC City B-1
ABC City C-1

But this one is getting inserted like this
as I didn't use any iteration.

storename storelocation partnum
ABC City A-1|B-1|C-1


Can anyone suggest me a highlevel logic to insert as a separate row in the table.

Thanks in advance,
Mary Gerald...

This message has been edited. Last edited by: <Kathryn Henning>,

Sample input

 
<SEARCH>
<STORENAME>ABC</STORENAME>
<STORELOCATION>City</STORELOCATION>
<PRODUCT>
<PARTNUM> A-1 </PARTNUM>
<PARTNUM> B-1 </PARTNUM>
<PARTNUM> B-1 </PARTNUM>
</PRODUCT>
.
.
</SEARCH>

Save your sample as mary.xml and then from New, Synonym select the XML adapter and create a synonym using the xml as a source. Sample data returns separate rows. Then use DataMigrator to load.

Thanks for the reply clif.

But looks like the screen shot is for Iway DataMigrator.

I think I wasn't clear enough.

I need this in Iway Integration Tool.