on 04-12-2007 5:07 PM
Hi @,
I have a scenario where i have to split an XML file conatining 10000 records into 1000 records per message .Is it possible to do without BPM ?
If not then how to use BPM to split count into 1000 each records?
Thanx to all in advance
yep...it is possible using context handling
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Priya,
Correct me if I am wrong. As per the scenario your source will have an occurance of 1:1 containing 10000 records. Which you have to split into a target message which would be having 1:unbound occurance and should containing multiple 1000 records in it.
In this scenario, we can use the graphical mapping to get it done. For the root element in the target message we would require an UDF to be created using Queue mapping. In the user defined function we need to check the value to 1000 and do the need full.
The second thing should be taken care in this context. We can implement this by using multi mapping without using BPM, if the integration server and the adapter engine is on the same host.
Hope this helps your cause.
Indranil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Priya,
While reading you always read 1000 records at a time. Check this document for help on this.
See in section 3.2 Module configuration table. It says:
Plain2XML xml.recordsetStructure NameA,1,NameB,*,NameC,1
So here for structure A only one record will be there, for B multiple and for C one record.
Instead you put 1000 and read it into XI.
---Satish
say if ur file contains 5 records do u want to have 5 messages...i.e. 1 record 1 message ? or 5 records in 1 messsage and again 5 records in second message?
Message was edited by:
Prabhu S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Its like whatever be the number of records i have to break them into multiple messages consisting up of my count like 5 then if it has 13 records then i should get 5,5,3 ( 3 messages ) like this .If it is less than 5 then 1 mesage but if it exceeds tht then each message must contain not more than above mentioned numer
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.