on 04-25-2008 10:29 PM
Hi,
I have a query related to mapping. Scenario is more like file-xi-soap.
The requirement is that there will be multiple records in the file and it has to create only one message for all the records.
Source structure:
<src_msg> 1..1
<data_records> 1..1
<row> 0...unbounded
field 1
field 2
field 3
field 4
</row>
</data_records>
</src_msg>
Target structure
<target_records> 1...1
field1
field2
field3
field4
field5
</target_records>
So for ex: the message in source file is like
200, 12, 34, 56, 78, 90, 785678
200, 12, 34, 56, 78, 90, 785679
200, 12, 34, 56, 78, 90, 785680
200, 12, 34, 56, 78, 90, 785681
200, 12, 34, 56, 78, 90, 785682
Here last field value is changing for the same 200 value which is there in the first field.
for the above mentioned multiple records in .txt file I should have one traget message containing all the records.
Can anybody suggest the possible mapping without using BPM so that it should generate only one target message for the above example.
In file content conversion of source i used the recorset per message but it was not working.
I also tried multimapping but in that case message structure was changed as message , message 1 , target_records. So I was not able to use it as requirement is to generate the following target structure:
<target_records> 1...1
field1
field2
field3
field4
field5
</target_records>
Can any body suggest good solution to my problem. Correct solution will be awarded with full points.
Thanks & Regards
Prabhat
Hi Prabhat,
If i understand ur point correctly, u want that if the node row occurs n times your element field5 should occur n times. This can be achieved using the node function useOneAsMany.
Lets say your element field4 is mapped to target side element field5, in this case you can use the useOneAsMany function. You map your source side field field5 and node row to the target side field field5.
This way for your target side field field5 will occur as many times as your source side node row occurs. I hope this helps.
Thanks and Regards,
Sanjeev.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
any solution???
thanks & regards
prabhat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I'd suggest designing a 1:n message mapping to achieve this (but I think you will have to deal with async intfs to do it) ... You will have to choose the suitable occurence settings for source (ie, 1) and target (1 to unbounded) and create message mapping accordingly (1:n will create additional namespaces, so you'll have to take them into account when creating it)
Hope this helps
Chris
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.