Mapping multiple source structures with single target structure

[Former Member]

Hi all

I am working on a proxy to JDBC scenario where the proxy structure contains 10 records but only one record is inserted in the target table with only one structure.Now there are three fields repeating in all the 10 records which should be mapped to target structure which also has same fields...............as shown below

Record access

id id

key1 key1

key2 key2

record

id

key1

key2

.............

..............

please sugest me a solution for mapping id,key1,key2 on source side from all records to target side?

Thanks in advance

Raghu.

[henrique_pinto]

Raghu,

I'm not sure if I have followed your necessity, but you could try it like this.

1st. File Content Conversion, from flat file to XML (keep 10 separated records).

2nd. Message Mapping, from source XML to target XML.

In Message Mapping, do it like this:

in target structure, right-click on the unbounded node, which should be mapped from the several records. Then select "Duplicate entry". Do that again and again until you have as many duplicate target nodes as records in source message (in your example, you need 10 target nodes). Then, for each duplicated node, map one of the input record structures.

That should work.

Regards,

Henrique.

[Former Member]

Hi Raghu,

You can try Java Mapping (DOM) or XSLT mapping. it is more easy for complex mapping.

Regards

Fernand