on 12-18-2008 6:25 AM
Hello experts,
I am working on an interface where i need to split files within BPM.
I know,i can achieve it in Message Mapping by mapping Recordset to Target structure and then using Interface Mapping within Transformation step.But i dont want to follow this.Is there an alternative way to achieve this within BPM.
I have an input file with multiple headers and i need to split for each header.My input file looks like this:
HXXXXXABCDVN01
MXXXXXXXXXXXXXX
MXXXXXXXXXXXXXX
SXXXXXXXXXXXXXX
HXXXXXABCDVN02
MXXXXXXXXXXXXXX
MXXXXXXXXXXXXXX
SXXXXXXXXXXXXXX
HXXXXXABCDVN03
MXXXXXXXXXXXXXX
SXXXXXXXXXXXXXX
Is there a way, where i can specify this condition within BPM , that split files for every H.
Thanks in advance.
Regards,
Swathi
Hi,
have your target structure with occurence as 0...unbounded in the mapping and map the header filed to the root node (repeating parent node) of the target structure....this will create as many target messages as the header fileds....if you want to send these messages separately then use a block in BPM with ForEach option....
Splitting and Dynamic configuration can be applied in the same mapping.
Regards,
Abhishek.
Edited by: abhishek salvi on Dec 18, 2008 12:59 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prateek..
The occurance of H is not fixed...
I am using Dynamic Configuration udf in Message Mapping to extarct the company code from my header and to append it with the source file name to get my target file name.But i could not achieve splitting of file and Dynamic Configuration in one single Message Mapping.
So currently,i have just used Dynamic Configuration in Message Mapping.
So i want to achieve splitting in BPM.
Can you please suggest me a way out.
Regards,
Swathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the occurrence of H is fixed after 4 records, then you may use FCC option "Recordset Per Message" = 4.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
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.