multimapping in integrated configuraton

[Former Member]

i am doing a file to databse scenario

i get a record, and i update or inset it in a databse table. It' the record of deleted materials. wwhenever a material is deleted hat material detils will be updated in a databse table

this scenario working fine

now i have to do a modification

whenever these records are deleted, i have to update the deleted records in a table and also delete it from another table.

i have to do two operations at the databse table in two different tables

can i use multimapping

source datatype is same

target side i create one more datatype for receiver. then message type also..

in receiver service interface, i create one more operation and refer the second message type

multimapping with both and multiple operatins as well

operation mapping also

then in ICO, do as normal.

i use one receiver com channel for the scenario...the same jdbc channel that i use now.

will this work? I mean this scenario

i was wondering whether the receiver jdbc channel will send two different statement formats at the same time

[former_member184720 · Accepted solution]

i don't think you need multimapping here

You can have two statements in your structure to act on separate tables in the same dB

You just need to create the other segment based on the above condition you stated

Refer to

[Former Member · Accepted solution]

i created with multimapping and it's working..

[former_member184720 · Accepted solution]

I know that it works but you don'the need multimapping to achieve

[Former Member · Accepted solution]

thanks for giving a much shorter and easier method to do it