Mapping for Transformation Step in BPM

[Former Member]

Hi all,

I need to split rows in transformation step in BPM,

My question is how to perform a mapping,

My source message(containing many rows) looks like:

<resultset>

<row>

<ID>1</ID>

<Name>A</Name>

</row>

<row>

<ID>2</ID>

<Name>B</Name>

</row>

Now I need to split this message to n (here 2 for example) messages looking like:

<Msg1>

<ID>1</ID>

<Name>A</Name>

</Msg1>

and the next one:

<Msg2>

<ID>2</ID>

<Name>B</Name>

</Msg2>

The problem though is that I don't know the number of rows I get from the DB...

Can anyone help me please?

Thanks

[Former Member]

Hi,

Since u r not sure about the number of rows u r gonno get from the db,so give ur occurance of the rows as 0..ub.and u need to create a messgae split in ur mapping so create a target message with occurance 0..ub.

so when u perform the mapping for every row message a target message will be generated.And import ur mapping in the transformation step in BPM.

for further reference chk out this link

/people/narendra.jain/blog/2005/12/30/various-multi-mappings-and-optimizing-their-implementation-in-integration-processes-bpm-in-xi

regards

jithesh

[Former Member]

Thanks,

Solved the problem...

Thank you for your help...

Due to technical problems can't reward the answers,

Sorry...

[Former Member]

Hi,

For each <row> you would want to create a new <msg> tag right?

For this, make sure that the source <row> tag is 0 to unbounded.

In the target message type, the <Msg> tag must be 0 to unbounded.

So now, for every row tag, a corresponding <Msg> tag is created in the target.

Carry out the mapping in the usual way after this.

In your BPM, in the transformation step, import this message mapping.

Regards,

Smitha.

[Former Member]

Hello,

Just in case you don't know where to set the mapping to 1:n mode (in the message mapping screen):

Go to the 'Messages' tab, and change the occurance of the target message to 0-unbounded.

Then go back to the 'Design' tab and map the 'row' element to the target message (Message type) name.

Hope that helps,

Ofer

[former_member91687]

Hi Dmitry,

You can try doing 1:n mapping in this case. Since the number of rows being returned is unknown, the occurance can be specified as 0 to unbounded. The steps to be followed for mappings based on message split can be found here:

http://help.sap.com/saphelp_nw04/helpdata/en/42/f3ca2529491bc7e10000000a11466f/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/42/f3b31d48fb1bc8e10000000a11466f/frameset.htm

I guess your requirement needs you to use a bpm, however the same is possible without a bpm also as explained in this weblog: /people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

Regards,

Chandra