how map source schema to destination schema

See more:

biztalk

Hi All,

I have two schema source and destination with following structure.


<ns0:productreq xmlns:ns0="http://ProductOrder.ProductResuest">
<custmorid>CustmorId_0
<requestid>RequestId_0
- <products>
<productid>ProductId_0
<quantity>Quantity_0

- <shippinginfo>
<city>City_0
<state>State_0
<country>Country_0


and

<ns0:productdata xmlns:ns0="http://ProductOrder.RequestData">
<custmorid>CustmorId_0
<requestid>RequestId_0
- <products>
<productid>ProductId_0
<quantity>Quantity_0
<availabequnty>AvailabeQunty_0
<priceperqty>PricePerQty_0

- <shippinginfo>
<city>City_0
<state>State_0
<country>Country_0



Now i want to map as follows

for every productid ,recored are fetched from database and mapped to destiantion schema.